Thanks for your answer. I have checked my sourcecode an I found a error. The correct statment is:
SELECT blue_NumberTable.N_ID, NumberTable.N_NUMMER FROM NumberTable LEFT JOIN AdressesTable ON AdressesTable.A_N_ID=NumberTable.N_ID WHERE AdressesTable.A_N_ID IS NULL; This statement works realy fine. And the join is with equal(=) conditions. Does anyone know if its possible to create a criteria to get that statement? Thank you... Daniel -- GMX ProMail mit bestem Virenschutz http://www.gmx.net/de/go/mail +++ Empfehlung der Redaktion +++ Internet Professionell 10/04 +++ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
