摘要： declare @order table(ID int,Name varchar(20))declare @Detail table(ID int,Price float)insert into @order(ID,Name) values(1,'aa'),(2,'bb'),(3,'cc')insert into @Detail(ID,Price) values(1,10.5),(2,12.3),(4,5.9)select * from @orderselect * from @Detail如果运行一下：left join 的联合查询select 阅读全文