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