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
On Wed, Oct 31, 2001 at 12:44:23PM -0500, Harpreet wrote:
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.
MySQL 4.0 has unions.
But if you're not using 4.0 yet (most