db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pfiester, Jan" <jan.pfies...@ict.fraunhofer.de>
Subject Problems to set up a subquery
Date Mon, 16 Oct 2006 15:40:05 GMT
Hi everyone,

I ran into problems to setup the following query using criteria:

SELECT DISTINCT * FROM kundenadresse 
WHERE kundenadress_id NOT IN( 
	SELECT kundenadress_id FROM adressenreferenz
);

Could someone please give me some help to come up with a proper solution?
Hints for further reading on this topic would also be very much appreciated!

Many thanks in advance,
Jan

---------------------------------------------------------------------
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