你不知道的join的语法

于 2010-07-14 14:59:56 发布 · 119 阅读

文章标签：

本文介绍了两种不同的SQL查询方法，通过使用多个表之间的连接操作来获取客户和供应商的相关信息。第一种方法利用了LEFT OUTER JOIN结合多个JOIN语句，第二种则是将所有JOIN语句并置书写。这两种方式都能有效地从数据库中提取所需的数据。

你不知道的join的写法

一 select distinct c.companyname as customer,s.companyname as supplier
from sales.customers as c
left outer join

sales.orders as o
join
sales.orderdetails as od
on
o.orderid=od.orderid
join
production.products as p
on
p.productid=od.productid
join
production.suppliers as s
on
s.supplierid=p.supplierid

on o.custid=c.custid

二 select distinct c.companyname as customer,s.companyname as supplier
from sales.customers as c
left outer join
sales.orders as o
join
sales.orderdetails as od
join
production.suppliers as s
join
production.products as p
on
s.supplierid=p.supplierid
on
p.productid=od.productid
on
od.orderid=o.orderid
on
o.custid=c.custid