Re: two tables, one result set, but no join!

From: <andrewst_at_onetel.com>
Date: 31 May 2005 09:12:24 -0700
Message-ID: <1117555944.495032.106360@o13g2000cwo.googlegroups.com>

Raj wrote:
> "Paul" <paulsnewsgroups_at_hotmail.com> wrote in message
> news:lo1p9111m6mnai07htbi96pv8qad6h45hd_at_4ax.com...
> >
> > andrewst_at_onetel.com wrote:
> >
> >>Use UNION.
> >
> >
> > Wouldn't UNION ALL be better in case there are duplicates?
> >
> >
> > Paul...
>
> Hi all,
>
> I didn't receive Andrew's post...could it be reposted for my benefit? It
> was unavailable and deleted from my news server.

All I said was "Use UNION." (as you can see in the quoted text above). That was rather terse of me. Here's an example:

SELECT a,b,c FROM x
UNION
SELECT a,b,c FROM y; Received on Tue May 31 2005 - 11:12:24 CDT