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: "Rizados"
Date: Wed, 22 Aug 2007 22:36:24 +0000 UTC
Newsgroups: macromedia.coldfusion.cfml_general_discussion
Whoops! It didn't like that.
 Code was:

                        <cfquery name="myQuery" dbtype="query">
                                        SELECT var1, var2, var3, var4, var5
                                        from Query1
                                        WHERE var1 NOT IN (SELECT var1 from 
Query2) 
                                </cfquery>      

  I get this error:

 [b]Query Of Queries syntax error.[/b]
 Encountered "var1 NOT IN ( SELECT. Incorrect conditional expression, Expected 
one of [like|null|between|in|comparison] condition, 




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