多表联接1.sql

简单的sql语句 数据与汇总。 高手多多指点。

use joindb
go

select buyer_name,buyers.buyer_id,qty from buyers
inner join sales
on buyers.buyer_id=sales.buyer_id
go


select buyer_name,buyers.buyer_id,qty from buyers
left outer join sales
on buyers.buyer_id=sales.buyer_id
go

select buyers.buyer_name,qty from buyers
cross join sales
go