Odd the query didn't go through.. here it is again:
SELECT o.id, o.name, o.description
FROM #request.optionTable# o
LEFT OUTER JOIN #request.productOptionTable# po
ON po.optionid = o.id
WHERE po.productid NOT IN ('#url.productid#')
> 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.
>
>
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
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
