macromedia.coldfusion.cfml_general_discussion
[Top] [All Lists]

Re: Comparing two queries yields one result too many

Subject: Re: Comparing two queries yields one result too many
From: "cf_dev2"
Date: Wed, 22 Aug 2007 22:52:23 +0000 UTC
Newsgroups: macromedia.coldfusion.cfml_general_discussion

I don't know if QoQ's supports that type of IN clause. IIRC they only support 
an IN clause with constants. 

 Have you tried a LEFT JOIN in a regular db query?

 SELECT   t1.var1, t1.var2, t1.var3, t1.var4
 FROM       yourTableA t1 LEFT JOIN yourTableB t2
                   ON t1.var1 = t2.var1
 WHERE   t2.var1 IS NULL


<Prev in Thread] Current Thread [Next in Thread>