How do I select two columns as one in MySQL?

acidbox

Lets say table A has a field called user_id and table B has a field called user_number. How do I call them in one select statement and merge the results into one column of results?

I tried selecting them both "AS new_user_id" but that just made to seperate columns of results with the same heading.

Any ideas?

eoghain

Use the CONCAT() function in MySQL.

SELECT CONTAT(tablea.field1, tableb.field2)
  FROM tablea, tableb

acidbox

I dont want to merge the results into one record, I simply want the same results from both tables to be selected as if they were from one.

From the looks of CONTACT, it appears that it simply joins two fields into one.

For example

TABLE_1

user_id | user_name
1 | BOB
2 | JERRY
3 | TOM

TABLE_2

user_num | username
42 | ANDY
51 | DAVE
64 | BILL

I want to

SELECT one.user_id AS new_user_id, two.user_num AS new_user_id FROM TABLE_1, TABLE_2

and I want the results to be like

new_user_id

1
2
3
42
51
64

The records aren't merged, only the fields. Is this possible?

Thanks again.

tsinka

Hi,

you can do that with a UNION query:

(SELECT user_id AS new_user_id FROM TABLE_1)
UNION
(SELECT user_num AS new_user_id FROM TABLE_2)

Use UNION if you want to get distinct ids or UNION ALL to get all ids even if an id exists twice.

Which MySQL version do you have ?

Thomas

acidbox

UNION was what I was looking for. Thanks for the help and the example.