Home NOT IN with multiple select statements
Reply: 0

NOT IN with multiple select statements

user405
1#
user405 Published in June 19, 2018, 6:18 pm

I need to do the following but T-SQL has a problem with how I have multiple select statements within the NOT IN

select * from table1 where ParamID not in 
(select paramid from tbl2 
 or 
 select paramid from tbl3 
 or 
 select paramid from tbl3) 

I get an error: incorrect syntax near select

Is there another way to do what I am trying to do.

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.329682 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO