> 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.
Or how about
Select issue.issID
>From issue left outer join issueOption on issue.issID=issueOption.issID
Where issueOption.issID is NULL
Not sure which is faster, the IN or LEFT OUTER JOIN
Philip Arnold
Technical Director
Certified ColdFusion Developer
ASP Multimedia Limited
Switchboard: +44 (0)20 8680 8099
Fax: +44 (0)20 8686 7911
www.aspmedia.co.uk
www.aspevents.net
An ISO9001 registered company.
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
______________________________________________________________________
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
