Victor How about generating a temporary table with the results of both queries ?
Or open two recordsete and merge them in your code ? Freddie -----Original Message----- From: Victor Spång Arthursson [mailto:[EMAIL PROTECTED] Sent: Sonntag, 26. Oktober 2003 16:56 To: [EMAIL PROTECTED] 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! Regards, Victor -- 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]