Not In

Question posted by: jags79 (Newbie) on September 22nd, 2008 07:07 AM

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.

Quote | Subscribe

1 Answer Posted

iburyak September 23rd, 2008 09:14 PM

Expert - 1,013 Posts

#2: Re: Not In

Depend on your data try one of these:

Expand|Select|Wrap|Line Numbers

	
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.

Not the answer you were looking for? Post your question . . .
197,022 members ready to help you find a solution.
Join Bytes.com

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 197,022 network members.

Post your question now . . .
It's fast and it's free

Top Microsoft SQL Server Contributors

Not In

What is Bytes?

Popular Articles

Top Microsoft SQL Server Contributors