Very Computer

can i write a query like this..

select * from X where
X . a , X . b in (select a,b from C where <condition> )

regards
sunny

Perhaps something along these lines will work for you:

SELECT X.*
FROM SomeTable X
INNER JOIN (select a,b from C where <condition> ) Y ON X.a = Y.a AND X.b =
Y.b

--
Keith, SQL Server MVP

Quote:> can i write a query like this..

> select * from X where
> X . a , X . b in (select a,b from C where <condition> )

> regards
> sunny

cool..
 i was looking if it was corect or not.. seems its gonna work the same way i
wanted..
thanks dude
sunny

Quote:> You can re-write this using EXISTS like:

> SELECT * FROM X
>  WHERE EXISTS (SELECT *
>                  FROM C
>                 WHERE C.a = X.a
>                   AND C.b = X.b
>                   AND ....)

> --
> - Anith

You can re-write this using EXISTS like:

SELECT * FROM X
 WHERE EXISTS (SELECT *
                 FROM C
                WHERE C.a = X.a
                  AND C.b = X.b
                  AND ....)

--
- Anith

hi
the problem was..........

select * from X where
 X . a , X . b in (select a,b from C where <condition> )
------------
Can i write the above query like this.. ( i dont want to use joins as it is
a bit complex query only a part of which i had sent to you)
Will the below solution return the same results as i need in the above one

select * from X where
(exists (Select a, b from table1  w  where <condition1>  and  X.b = w.b  and
X.a = w.a ))

Thanks & regards
sunny