List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:August 28 1999 9:04pm
Subject:Re: UNION instead of JOIN
View as plain text  
>>>>> "Benjamin" == Benjamin Pflugmann <philemon@stripped> writes:

Benjamin> Hi.
Benjamin> On Tue, Aug 24, 1999 at 05:50:03PM -0700, jmmmj@stripped wrote:
Benjamin> [...]

>> He suggested to use UNION
>> does this command exist in mysql?

Benjamin> No.

>> if so....
>> how do i use it
>> if not, why not? :)

Benjamin> Because there were more important things to do and nobody has
Benjamin> implemented it yet? ;-)

Hi!

Instead of UNION you can use something like:

CREATE TEMPORARY tmp SELECT ....
INSERT INTO tmp SELECT ...
select * from tmp;
drop table tmp;
Thread
UNION instead of JOINMick Hanna24 Aug
  • Re: UNION instead of JOINBenjamin Pflugmann24 Aug
    • Re: UNION instead of JOINMichael Widenius29 Aug