Posted by dumbledad@gmail.com on 09/06/05 18:40

Thanks Simon. I'd been following a heuristic that "not exists" would
take longer than outer joins with a null test. I'll need to think that
through more. Your solution is exactly what I was after.

• Next in forum: Re: Total Newbie - Maintainenance of SQL Database
• Prev in forum: Total Newbie - Maintainenance of SQL Database
• Thread view: Re: Replacing SELECT with a value in an OUTER JOIN

[Reply to this message]