摘要:
--使用Northwind--连接查询--内连接(Inner Join)select p.* from Products p inner join [Order Details] o on p.ProductID=o.ProductID goselect p.*,c.* from Products p inner join Categories c on c.CategoryID=p.CategoryID go--1、左外连接select p.*,c.* from Categories c left outer join Products p on p.CategoryID=c.Categor 阅读全文