I'm having trouble with this query.
There are two tables, issue and issueOption.
There is a one-to-many relationship between issue ("one") and issueOption
("many"). issID is the key that joins the two tables.
I want to select all records from issue that are not in the issueOption. In
other words, get all issues without options.
Thanks in advance,
Nick
______________________________________________________________________
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
