Hi...
I have an query for mysql that looks like:
SELECT "group" as type FROM mytable WHERE id ="101010" UNION SELECT "individual" as type FROM myothertable WHERE id="101010"
The strange result if only one result displayed from myothertable, so the "type" will become "indiv" instead of individual.
But when I tried to switch the query become :
SELECT "individual" as type FROM myothertable WHERE id="101010" UNION SELECT "group" as type FROM mytable WHERE id ="101010"
it could displaye the result correctly. I dont know why .. is this mysql bug ?
-- ======================= Best Regards Adwin Wijaya
http://masterkuya.blogspot.com/ http://www.kuya-kuya.net http://www.e-rhema.net =======================
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
