MySQL:UNION -- 多张表查询出的结果集合并

Demo Code:

CREATE TABLE TABLE1 (ID1BIGINT(50) PRIMARY KEY,NAME1varchar(50),PSW1varchar(50));CREATE TABLE TABLE2 (ID2BIGINT(50) PRIMARY KEY,NAME2varchar(50),PSW2varchar(50));INSERT INTO TABLE1(ID1, NAME1 ,PSW1)VALUES(1,'user1','psw1');INSERT INTO TABLE2(ID2, NAME2 ,PSW2)VALUES(2,'user2','psw2');SELECT T1.ID1 ID_FIELD, T1.NAME1 NAME_FIELD, T1.PSW1 PSW_FIELDFROM TABLE1 T1UNION SELECT T2.ID2 ID_FIELD, T2.NAME2 NAME_FIELD, T2.PSW2 PSW_FIELDFROM TABLE2 T2;

The Query ResultSet as follows :

ID_FIELDNAME_FIELDPSW_FIELD1user1psw12user2psw2