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