alternate to "NOT IN " query

22 Dec 2005 5:19 AM

Vikram

any better way of writing this
Select serialnumber from tbl_test2
    where serialnumber
          not in (select serialnumber from tbl_test) and
                  exportedflag=0

22 Dec 2005 5:24 AM

Uri Dimant

Vikram
Select serialnumber from tbl_test2
    where not exists
           (select * from tbl_test where tbl_test.serialnumber
=tbl_test2.serialnumber )
and   exportedflag=0

Show quote

"Vikram" <aa@aa> wrote in message
news:OE88tbrBGHA.3396@tk2msftngp13.phx.gbl...
> any better way of writing this
> Select serialnumber from tbl_test2
>    where serialnumber
>          not in (select serialnumber from tbl_test) and
>                  exportedflag=0
>
>

22 Dec 2005 11:43 AM

Nick Stansbury

Also:

Select SerialNumber from tbl_test2
left join tbl_test on tbl_test2.SerialNumber = tbl_test.SerialNumber
where tbl_test.serialNumber is null and exportedFlag=0

Show quote

"Vikram" <aa@aa> wrote in message
news:OE88tbrBGHA.3396@tk2msftngp13.phx.gbl...
> any better way of writing this
> Select serialnumber from tbl_test2
>    where serialnumber
>          not in (select serialnumber from tbl_test) and
>                  exportedflag=0
>
>