>>>>> "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;