db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Müller" <daniel0...@gmx.de>
Subject Join or Where Clause
Date Tue, 07 Dec 2004 08:11:12 GMT
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


Mime
View raw message