weixin_46051617的博客

1.inner join， 保留两张表 条件都匹配的数据2.left join, 返回 左边满足条件的3.right join, 返回 右边满足条件的4.full join, 返回左右表都不满足条件的 数据1.SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo FROM Persons INNER JOIN Orders ON Persons.Id_P=Orders.Id_P ORDER BY Perso...