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

On Tue, 4 Dec 2007 01:36:01 -0800 (PST), FunBoy
<monojitaich@gmail.com> wrote:

>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
thanks. I take it this '-' stops the data from accidentally
matching?
Jeff

• Next in forum: Re: SSIS is pathetic with ODBC connections ...
• Prev in forum: Re: multi column sub select equivalent for sql server 2005
• Thread view: Re: multi column sub select equivalent for sql server 2005

[Reply to this message]