> > 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)
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.