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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org