Posted by FunBoy on 12/04/07 09:36

On Dec 4, 9:15 am, Jeff Kish <kishjj...@charter.net> wrote:
> 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


It can be done slightly different way,


select table1.col1,table1.col2,table2.col3,table4.col4
where table1.col1 = table2.col3 and
table2.col3 = table4.col5 and
cast(table1 as varchar(20)) +'-'+cast(col1 as varchar(20)) not in(
select cast(table2.col4 as varchar(20)) + '-' + cast(table2.col5 as
varchar(20)) from table2)

Regards
Monojit

[Back to original message]