Re: Selecting data from 2 tables.

[Ed Curtis]

> I think a quick way to write this query would be
> (http://dev.mysql.com/doc/mysql/en/UNION.html):
>
> ( SELECT magazine FROM pages )
> UNION DISTINCT
> ( SELECT magazine FROM pdflog )
> ORDER BY magazine;

 Thanks for all the help on this one. I just also realized that the server
I'm working with has version 3.23.x of MySQL. My only other option now is
to create a temp table with distinct data from both tables, is it not?

Ed