表a 表b 左链接 //a左连接b select * from a LEFT JOIN b on a.id = b.id; 右链接 //a右链接b select * from a RIGHT JOIN b on a.id = b.id; 内连接 select * from a INNER JOIN b on a.id = b.id; 外连接 select * from a full join b on a.id=b.id; //mysql不好使 取两个表数据用UNION 笛卡尔积 SELECT * FROM a,b;