联表查询
#####################
SELECT *FROM TABLE1 AS ONEINNER JOIN TABLE2 AS TWOON ONE.T1_T2_ID = TWO.T2_IDWHERE 查询条件
#####################
异或
#########################
SELECT *FROM TABLE1 AS ONE,TABLE2 AS TWOWHERE ONE.T1_T2_ID = TWO.T2_ID AND 查询条件;
#########################