SQL Query Help please

Dear All,

I have the following select:

Select account_no from table1
where account_no not in (select account_no from table2).

I am trying to say that give me the account_no's in table1 that are not in table2.

In the result I do not get any rows back and I know for a fact that there are rows in table1 that are not in table2. (Table2 has more rows than table1)

Thanks in advance
mujahid_at_pharmco.demon.co.uk Received on Sat Oct 17 1998 - 11:37:33 CDT