Query Help!

[2742]

Hi Every One
I am having a bit of a problem writing this query! It should be simple.

Here's my problem. I have two tables - one with just customer_numbers and the other with the customers record including thier customer_number. I want to select all customer_numbers out of table one which don't appear in the second table(customer records).

select cust_no from purge left outer join testcustomers
on cust_no != Account ; doesn't work!

Please help there must be a better way to do it!

Thanks

 

[2742]

It's alright i finally got it and yes is was simple.
The answer is:

select cust_no from a where a.cust_no not in (select cust_num from b)