等值连接又叫内链接 inner join 只返回两个表中连接字段相等的行 select * from A inner join B on A.id = B.id; #做法1 select * from A,B where A.id = B.id; #做法2