SQLQuery using IN Operator...

I wrote a query like the following.

Select * from emp where empno in (1000,2000,3000);

In emp table i have only one empno 1000.the above query returns the details about 1000.but i want to just show the not available numbers along with the result.is it possible ?..
Pls Help....

Thanx in advance.

I don't get what you want, but this is a 'not' part of:

In hav a table called sub_details having fields like mobile_no,name,balance,transdate.i have more than 2 lac records.the key field in this table is mobile_no.now i'm supplying a query to select the details of subscriber with a set of mobile_nos got from an external application(it may go upto 40000).

In that 40k numbers, most of them may not be present in sub_detail.

I used to show the available subscriber details with the select query using IN Operator. It shows only available details. But I want to show available and Not available details.

Sugest a Best Query.

thank you