From: Martijn Tonies
Date: October 28 2003 9:35am
Subject: Re: alternate syntax for UNION?
List-Archive: http://lists.mysql.com/mysql/152582
Message-Id: <011f01c39d36$c5048b30$0a02a8c0@seal>
MIME-Version: 1.0
Content-Type: text/plain;	charset="Windows-1252"
Content-Transfer-Encoding: 8bit

Hi Victor,

> > Desperately need some way to get around the fact that UNION is not
> > possible to use on mysql prior to version 4…
> >
> > Was just about to launch a site when it showed up that the hosting
> > provider was running version 3.xxxx
> >
> > Help!
>
> Come on now - don't make me change to postgreSQL ;)

:-) ... or Firebird :-)

Anyway, perhaps you can get around it by using a MERGE table?

(do note that my real-life MySQL knowledged is ... well, not a lot)


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions
http://www.upscene.com