Thanks for the reply, Aaron, but the CF app log is saying there's an error with "not exists" or "not in"...
So, the problem is definitely in that part. Just got to find the right syntax. I've always used "not in" in subqueries, but never used (that I can remember) a subquery inside an insert query. > -----Original Message----- > From: Aaron Rouse [mailto:[EMAIL PROTECTED] > Sent: Friday, May 16, 2008 10:58 AM > To: CF-Talk > Subject: Re: What's wrong with this query? > > When I have done this, I used a NOT EXISTS, so something like this random > example I just pulled from Google: > > http://archives.postgresql.org/pgsql-general/2003-06/msg01683.php > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305424 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
