Code Comments
Programming Forum and web based access to our favorite programming groups.
Re: select distinct from two tablesDon't know if UNION supported so assuming it isn't you could get them into 1 temporary table first -------- CREATE TEMPORARY TABLE temp SELECT country, code FROM table1 -------- Add table2 records -------- INSERT INTO temp SELECT country, code FROM table2 -------- then -------- SELECT DISTINCT country, code FROM temp -------- hth Barand http://members.aol.com/barryaandrew...agridguide.html easy data tables - and more ---------------------------------------- The post originated from PHP Freaks: ---------------------------------------- http://www.phpfreaks.com http://www.phpfreaks.com/forums
Post Follow-up to this message
Sponsored Links
Powered by vBulletin
Copyright 2000-2006 Jelsoft Enterprises Limited.
