多表联接1.sql

来自「简单的sql语句 数据与汇总。 高手多多指点。」· SQL 代码 · 共 19 行

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