Left outer join

Florian Bogeschdorfer fb at memedia.de
Thu Oct 2 16:47:11 CDT 2003


Hi I am trying to do a left outer join but get error 602 (Table not found)

I tried these syntaxes:

SELECT name,CRD_Number FROM KUNDENtable LEFT OUTER JOIN KUNDENKARTENtable
WHERE KD_ID = 1 AND CRD_KD_ID = KD_ID

And

SELECT name,CRD_Number FROM KUNDENtable|A LEFT OUTER JOIN
KUNDENKARTENtable|B WHERE A.KD_ID = 1 AND B.CRD_KD_ID = A.KD_ID

What is wrong?

TIA, Florian



More information about the Valentina mailing list