[Resolved] select DISTINCT from two fields

[perpetualshaun]

This may not be possible, but I want to write a statement that will pull a distinct list of numbers from TWO separate fields. Is that possible? For example, I thought something like this might work:

SELECT DISTINCT route_number_1 AS route. route_number_2 AS route FROM customers ORDER BY route_number_1 ASC, route_number_2 ASC

But when I run that in PHP MyAdmin, I get two columns instead of just one, and it appears to be only be a distinct list from one field, not both. Any ideas?

Thanks

[LordShryku]

Well, in the above, you're pulling two fields, so you're going to get two fields. DISTINCT works across everything you pull. So if you select DISTINCT two seperate fields, it will look for distinct combinations of the two fields. My advice would be to pull the fields into an array with two seperate queries, and use [man]array_unique[/man] to kill off duplicates.