Need Query for the Problem in DB2

[abdularab]

I have 10000 accounts in my database

Now I have given a select statement like this

select acct_nmbr from acct_database
where acct_nmbr in (here I have given 6500 account numbers)

The select query fetched 6000 records,
but I dont know which 500 account numbers not present in the database.

I need a query to find the 500 missed records...

Please help me...

Thanks in advance

Abdul

[sundaylxf]

table a 10000 records
table b 6500 records


select * from b where acct_number not in(select acct_number from a)