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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux