By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,766 Members | 1,295 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,766 IT Pros & Developers. It's quick & easy.

Not In

P: 1
If any of the value doesnt exists in the values then the process Id should not come for that values

Like in the set of email id's if "AA" doesnt not exists then only those process_id
should be dispalyed who dont have that email id.
Sep 22 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,017
Depend on your data try one of these:

Expand|Select|Wrap|Line Numbers
  1. Select email_id from table_name where  not exists(select process_id from table_name)
  2. Or 
  3. Select email_id from table_name where  process_id is null
Good Luck.
Sep 23 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.