> Not sure I fully understand that > [snip] > So what would be the complete query ?
My bad, Justin... I was in a rush yesterday and misread your post -- in the past, I've had situations where you want to get records from table a that had no corresponding record in table b, so you could do a "select a.col1, a.col2, b.col1 from table a left outer join table b on a.col1 = b.col1" and filter on those where a.col2 = null (because it has no corresponding record with a record in table b). -- Aidan Whitehall <mailto:[EMAIL PROTECTED]> Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 Queen's Awards Winner 2003 <http://www.fairbanks.co.uk/go/awards> ________________________________________________________________________ This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
