Hello guys,
I cannot understand why does query type "make table" loose fields data from just "select" query type.
The code that access gives me looks like this:
Code:
SELECT STARMAN_AD_KATASTRIYKSUS.KATASTRITUNNUS, Esimene.*, STARMAN_EH_EHITIS_KATYKSUS.KAYK_ID INTO Finaalne
FROM (Esimene LEFT JOIN STARMAN_EH_EHITIS_KATYKSUS ON Esimene.EHIT_ID = STARMAN_EH_EHITIS_KATYKSUS.EHIT_ID) LEFT JOIN STARMAN_AD_KATASTRIYKSUS ON STARMAN_EH_EHITIS_KATYKSUS.KAYK_ID = STARMAN_AD_KATASTRIYKSUS.ID;
So when I just run this code as select, it gives me what I want aka everything from table "Esimene", KATASTRITUNNUS from table "STARMAN_AD_KATASTRIYKSUS" and also KAYK_ID from table STARMAN_EH_EHITIS_KATYKSUS
What this does not do, is put all those fields into new table called "Finaalne", fields are just blank.
I am so confused, does anybody has a clue what I might be doing wrong?
Thank you in advance,
Annu
EDIT*
Okay I will explain a little more, maybe the problem is related to previous actions.
First I made a table out of this code:
Code:
SELECT EE.*, Starman_eh_ehitis_aadress.EHIT_ID INTO Esimene
FROM EE LEFT JOIN Starman_eh_ehitis_aadress ON EE.ADR_ID = Starman_eh_ehitis_aadress.ADR_ID;
This worked like a charm.
Then I also wanted to make a table out of this code:
Code:
SELECT Esimene.*, STARMAN_EH_EHITIS_KATYKSUS.KAYK_ID INTO Teine
FROM Esimene LEFT JOIN STARMAN_EH_EHITIS_KATYKSUS ON Esimene.EHIT_ID = STARMAN_EH_EHITIS_KATYKSUS.EHIT_ID;
However this one made a table where field made from previous select and "make table" was also lost. aka now it made a table where Starman_eh_ehitis_aadress.EHIT_ID and STARMAN_EH_EHITIS_KATYKSUS.KAYK_ID are empty columns.
So in the end I tried eveything with one query:
Code:
SELECT EE.*, STARMAN_AD_KATASTRIYKSUS.KATASTRITUNNUS
FROM ((EE LEFT JOIN Starman_eh_ehitis_aadress ON EE.ADR_ID = Starman_eh_ehitis_aadress.ADR_ID) LEFT JOIN STARMAN_EH_EHITIS_KATYKSUS ON Starman_eh_ehitis_aadress.EHIT_ID = STARMAN_EH_EHITIS_KATYKSUS.EHIT_ID) LEFT JOIN STARMAN_AD_KATASTRIYKSUS ON STARMAN_EH_EHITIS_KATYKSUS.KAYK_ID = STARMAN_AD_KATASTRIYKSUS.ID;
But this did not work at all - gave me a error "Type mismatch in expression"