On 16 Sep 2004 at 2:24, ra8009 wrote:

>If I have customers and orders, how do I find the customers with no
>orders? Is the methos that I'm using below accurate and the best way?

Yes. At least it is the fastest method.

>SELECT *
>FROM CUSTOMERS C LEFT OUTER JOIN ORDERS O ON
>C.CUST_ID = O.CUST_ID
>WHERE O.CUST_ID IS NULL

SY, Dimitry Sibiryakov.