you can use temporary tables if need to work on the resultset else use two different queries. I think, that's the only option.
Nitin ----- Original Message ----- From: "Victor Spång Arthursson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 28, 2003 2:59 PM Subject: Re: alternate syntax for UNION? > > 2003-10-26 kl. 16.56 skrev Victor Spång Arthursson: > > > 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 ;) > > /.v > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
