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

Demo Code:

CREATE TABLE TABLE1 (
	ID1		BIGINT(50) PRIMARY KEY,
	NAME1	varchar(50),
	PSW1	varchar(50)
);
CREATE TABLE TABLE2 (
	ID2		BIGINT(50) PRIMARY KEY,
	NAME2	varchar(50),
	PSW2	varchar(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_FIELD
	FROM TABLE1 T1
UNION 
SELECT T2.ID2 ID_FIELD, T2.NAME2 NAME_FIELD, T2.PSW2 PSW_FIELD
	FROM TABLE2 T2;

The Query ResultSet as follows :

ID_FIELD	NAME_FIELD	PSW_FIELD
1	user1	psw1
2	user2	psw2