hi, i'm trying to select * through 3 tables - is the following syntax correct?
$sql="(SELECT * FROM mjp_cc)"; $sql="UNION"; $sql="(SELECT * FROM imc_cc)"; $sql="UNION"; $sql="(SELECT * FROM pmp_cc)"; $sql.=" ORDER BY savedccactivity DESC"; i basically just want to spit out the contents of these tables... also - how would this type of query work if the name 'savedccactivity' is different in all 3 tables? thanks redmond -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
