[suspicious - maybe spam] strange in MySQL Query.

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