联表查询
#####################
SELECT *
FROM TABLE1 AS ONE
INNER JOIN TABLE2 AS TWO
ON ONE.T1_T2_ID = TWO.T2_ID
WHERE 查询条件
#####################
异或
#########################
SELECT *
FROM TABLE1 AS ONE,TABLE2 AS TWO
WHERE
ONE.T1_T2_ID = TWO.T2_ID AND 查询条件;
#########################