左连接不论右表有无数据,只要左表有数据,就会查询到 SELECT * from A LEFT JOIN B ON A.id= B.id 右连接 2.SELECT * from A RIGHT JOIN B on A.id = B.id