JOIN用于对多表进行连接，可以是JOIN，LEFT JOIN，RIGHT JOIN，FULL JOIN，CROSS JOIN。JOIN,LEFT JOIN,RIGHT JOIN,FULL JOIN支持ON或者WITH条件约束。