union available in version 4.0 (alpha) now -----Original Message----- From: Harpreet [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 11:46 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Alternative for Union in MYSQL
I had a view on sqlserver which i am trying to convert to work with mysql. It uses a union which i believe does not work with mysql. What is another alternative for union. Sql with union: select a.asset_id,a.material_id,b.material_id as parent_material_id from lib_asset_tbl a inner join lib_asset_tbl b on a.parent_id=b.asset_id union select asset_id,material_id,'' from lib_asset_tbl where virtual_flag='N' Help is appreciated, Regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]