(a,b) not in ( select c,d from ... ) , is it possible ?SELECT *
FROM yourtable ot
WHERE NOT EXISTS (
SELECT *
FROM yourtable AS yt
WHERE yt.c = ot.a
AND yt.d = ot.b
)
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
"Hasan O." <hozavalsiz@.gmail.com> wrote in message
news:etbTbcobGHA.4040@.TK2MSFTNGP02.phx.gbl...
>|||Hi Tony,
Thank you for the information you supplied.
"Tony Rogerson" <tonyrogerson@.sqlserverfaq.com> wrote in message
news:%23$fhhhobGHA.724@.TK2MSFTNGP05.phx.gbl...
> SELECT *
> FROM yourtable ot
> WHERE NOT EXISTS (
> SELECT *
> FROM yourtable AS yt
> WHERE yt.c = ot.a
> AND yt.d = ot.b
> )
> --
> Tony Rogerson
> SQL Server MVP
> http://sqlserverfaq.com - free video tutorials
>
> "Hasan O." <hozavalsiz@.gmail.com> wrote in message
> news:etbTbcobGHA.4040@.TK2MSFTNGP02.phx.gbl...
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment