Not so easy SELECT statement (atleast not for me)

Hi everyone...

I have a table with 3 fields,

ID Lead Helper
1 John Peter
2 Bob
3 Larry John


and I would like to get distinct names for Lead and Helper in one column. Is that possible?

Thanks in advance,

Pauley

SELECT DISTINCT Lead
FROM tbNames
UNION SELECT DISTINCT Helper
FROM tbNames

davie,

Thanks for the quick response! Unfortunately Im only running mySQL 3.23 and UNION wasn't implemented until 4.x. Anyother suggestions, beside for upgrading :-)?

you could append them to a temporary table

you could append them to a temporary table

And thats exactly what i just found...

For anyone else with this issue:

CREATE TEMPORARY TABLE temp_union
SELECT DISTINCT Lead from signs;
INSERT INTO temp_union
SELECT DISTINCT Comm from `signs`;
SELECT DISTINCT * FROM temp_union ORDER by Lead;

Thanks for your help!

Pauley