Posted by Jeff Kish on 12/04/07 04:15

Can anyone tell me how to do this in sql server?
I am currently doing this query in oracle:

select table1.col1,table1.col2,table2.col3,table4.col4
where table1.col1 = table2.col3 and
table2.col3 = table4.col5 and
(table1.col1,table1.col2) not in
select table2.col4,table2.col5 from table2


it is the where two column values from any row are not found in any
row in table2 part that I can't figure out.



thanks
Jeff

• Next in forum: Re: multi column sub select equivalent for sql server 2005
• Prev in forum: Re: Automatically Archiving a Large Table
• Thread view: multi column sub select equivalent for sql server 2005

[Reply to this message]