函数学习 有些事，记下来是不错的选择...

sql连接INNER JOIN ON查询

INNER JOIN 关键字在表中存在至少一个匹配时返回行。如果表中没有匹配，则不会列出这些行。

SELECT a.AAA,b.BBB,c.CCC,d.DDD,a.MT,a.AAB,a.AAC,a.AAD,f.FFF FROM tableA AS a 
INNER JOIN
tableB AS b ON b.B_AAA = a.AAA
INNER JOIN
tableC AS c ON c.CCD = a.AAD
INNER JOIN
tableD AS d ON d.DDE = a.AAE
INNER JOIN
tableE AS e ON e.EEF = a.AAF
INNER JOIN
tableF AS f ON f.FFG = e.EEG
WHERE a.AAA IN (XXX,YYY,ZZZ);