Posted by Adwin Wijaya on 01/14/05 05:54

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
=======================

[Back to original message]