Re: Join vs Union

in general, i would suggest that you use the UNION or UNION ALL operator when you need to concatenate the result sets of two separate SELECT statements together, and use a "join" construct to match rows of multiple tables together in a single SELECT.

<subh2000_at_my-deja.com> wrote in message
news:8ha48f$t54$1_at_nnrp1.deja.com...
> Hi fellas,
>
> Can you suggest me as to when to use Join and when to use
 Union. I
> would also like to known which one gives better performance in
 terms of
> speed.
>
> Thanks,
>
> Subhendu.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Received on Sat Jun 03 2000 - 00:00:00 CDT