467,149 Members | 1,337 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,149 developers. It's quick & easy.

Not In

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
  • viewed: 907
Share:
1 Reply
iburyak
Expert 512MB
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.

Similar topics

3 posts views Thread by William C. White | last post: by
2 posts views Thread by Albert Ahtenberg | last post: by
3 posts views Thread by James | last post: by
reply views Thread by Ollivier Robert | last post: by
1 post views Thread by Richard Galli | last post: by
4 posts views Thread by Albert Ahtenberg | last post: by
1 post views Thread by inderjit S Gabrie | last post: by
2 posts views Thread by Jack | last post: by
3 posts views Thread by Sandwick | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.