> SELECT name
> FROM customer
> WHERE NOT EXISTS (
> SELECT customer_id
> FROM salesorder
> WHERE customer_id = customer.customer_id
> );
>
> Bruce, you may want to consider editing your next edition to include the
> above modification. WHERE ... NOT IN is a bad idea for any subselect on
> medium-large tables.
FAQ item mentions this, and section 8.2 shows eqivalency at the end of
the section.
--
Bruce Momjian | http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
