DB研討會 : [轉貼]兩個table的某個欄位合併

table_1
t1_name
a
b
c

table_2
t2_name
e
f
g

SELECT t1_name, t2_name 變成newName
FROM table_1, table_2

newName
a
b
c
d
e
f
g

SELECT t1_name, t2_name 變成newName
FROM table_1, table_2

SELECT t1_name as newName
FROM table_1
union all
SELECT t2_name as newName
FROM table_2

SELECT t1_name as newName FROM table_1
union
SELECT t2_name as newName FROM table_2

select concat(t1_name,t2_name) as newName from table_1, table_2;