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. ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists