I have a query that I am trying to get all my descriptions from my choiceTable that
are not found in my productChoiceTable that have a productid of a url.product value.
Basically if a choice id is found in the productChoiceTable that also has the
url.productid in the productid column, it is discarded in the result.
Here is my table layout:
choiceTable
id, choice, description
productChoiceTable
id,choiceid,productid
<!--- Current query that is returning 0 records (which is not the case). --->
SELECT c.id, c.description
FROM choiceTable c, productChoiceTable pc
WHERE c.id = pc.choiceid
AND pc.productid NOT IN ('#url.productid#')
Any suggestions apreciated!
Paul Giesenhagen
QuillDesign
______________________________________________________________________
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
