[suspicious - maybe spam] [suspicious - maybe spam] strange in MySQL Query.

[adwin wijaya <adwinwijaya@xxxxxxxxxxxx>]

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