Not In

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jags79
    New Member
    • Sep 2008
    • 1

    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.
  • iburyak
    Recognized Expert Top Contributor
    • Nov 2006
    • 1016

    #2
    Depend on your data try one of these:

    Code:
    Select email_id from table_name where  not exists(select process_id from table_name)
    Or 
    Select email_id from table_name where  process_id is null
    Good Luck.

    Comment

    Working...