[SOLVED] selecting those rows which are not in another table

[chet139]

Hi,

 

I want to be able to select the rows from the customer table - but only those customers who are not in the order table.....

 

Any ideas I tried these but obviously does not work:

 

select * from customer where customer.custId NOT in furniture.order.custId

 

select * from customer where customer.custId NOT = furniture.order.custId

 

Any suggestions.

 

Thank You

 

 

[chet139]

SOLVED. Can close this topic if required.

 

select * from customer where customer.custId NOT in (select furniture.order.custId from furniture.order)

[fenway]

Though I'd prefer a left join.

[aschk]

I also would prefer a LEFT JOIN to avoid issues with the whole dataset from `order` being brought back, which I can only imagine is rather large...