>Hi,
> I have a subquery which made use of UNION. Is there any INTERSECT equivalent SQL statement which can be used with UNION?
>
>((select * from table1
>UNION
>select * from table2) INTERSECT
>(select * from table3))
>
>
>Thank you
Isn't an intersect the same thing as an inner join?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer