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
>>Can i somehow create a temporary table and add all the rows i need and do
a select query from that temp table.
Yeah, that's the easiest way to do it.
Create temporary table A.
insert into A select
insert into A select
select * from A
If you want to mimic 'insersect' features
Corporations Inc.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bill Adams
Sent: Wednesday, October 31, 2001 1:23 PM
To: [EMAIL PROTECTED]
Cc: 'Mysql'
Subject: Re: Alternative for UNION
Harpreet wrote:
> I had a view on sqlserver which i am trying
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.
>
> Sql with union:
>
> select a.asset_id,a.material_id,b.material_id as pa
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
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
