你不知道的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