Concatenating two SELECT results

WebHelper Joined: 30 Jul 2002 Posts: 56 Location: UK

Is there a way to concatenate two sets of results like this:

SELECT UserID, Name FROM Users WHERE Disabled = 0

+

SELECT UserID, Name FROM Users WHERE Disabled = 1 ORDER BY Name

Oh, and is the syntax for those queries correct or do I need "==" instead of "=" ?

WebHelper Joined: 30 Jul 2002 Posts: 56 Location: UK

I have done some investigation to find that there is the UNION statement available in MySQL version 4.0.0 or higher. Would it be better to perform the union in PHP and assume MySQL version 3.x on web servers?

Posted: Wed Jul 31, 2002 1:27 pm (21 years, 8 months ago)

SELECT UserID, Name FROM Users WHERE Disabled = 0 OR Disabled = 1 ORDER BY Name

Wouldn't that give you a list of users where Disabled was 1 or 0.

WebHelper Joined: 30 Jul 2002 Posts: 56 Location: UK

Yes, but I don't want the ones that aren't disabled to be sorted Wink

Posted: Wed Jul 31, 2002 2:33 pm (21 years, 8 months ago)

i thought that was too easy - I have no idea then Very Happy