how to re-write a query to work in Mysql 3.23

[nicr]

Hi there.

One of our developers is using the following query in PHP 4.1.10a:

SELECT user_surname s, user_firstname f, membership_type m, user_email e
FROM registered_users
WHERE membership_number is not null
AND user_surname like 'A%'
UNION
SELECT surname s, firstname f, membership_type m, email e
FROM members
WHERE surname like 'A%'
AND membership_number NOT IN
(SELECT membership_number FROM registered_users WHERE membership_number is not null)
ORDER BY s, f ;

The problem is that our live (production) server runs MySQL 3.23.58 and this query doesn't work. Can anyone help me re-write the query in to a compatible version for 3.23.58? After reading the manual page, it appears that UNION queries aren't supported in < 4.0 but I'm not sure how to achieve the same functionality. Please help me

Nic

 

[johnwm]

You can use a Temp table as illustrated in the second user comment at the bottom of

http://dev.mysql.com/doc/refman/4.1/en/union.html

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller