Why "NOT IN"? Is the url.productid a list? Have you tried "<>"?
-----Original Message----- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 11:40 PM To: CF-Talk Subject: OT: JOIN Query I am trying to run a query that joins two tables and returns all the items that are listed in the optionTable, BUT NOT the ones who have the productid of the url.productid in the productOption table. (o.id = po.optionid) Here is the query I have thus far and it returns no results .. if I replace NOT IN with = '#url.productid#' it returns all the options associated with that product. ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
