join= inner join= cross join(都可以使用ON过滤)left join=left outer join:左外连接right join=right outer join:右外连接full join=full outer join:全外连接(mysql不支持UNION代替)natural join: 自然连接(不能使用ON)