> 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
