第三章 10-using子句 the using clause--Mosh mySQL

1，on o.customer_id=c.customer_id，如果列名称一样的，可以简化成using（customer_id），列名称不一样的不能用using

use sql_store;
select
o.order_id,
c.first_name,
sh.name as shipper
from orders o
join customers c
using(customer_id)
join shippers sh   #如果加上left，那么order_id都会出现，且shipper可能有null的情况出现
using(shipper_id)

2，复合主键的情况下如何简化？之前我们谈到过复合主键的问题

分别是oi oin的列

select *
from order_items oi
join order_item_notes oinn
on oi.order_id=oin.order_Id
and oi.product_id=oin.product_id

后两行改成using(order_id,product_id)

练习：写出查询，生成右图的表

答案：

use sql_invoicing;
select
p.date,
c.name as client,
p.amount,
pm.name as payment_method
from payments p
join clients c
using (client_id)
join payment_methods pm
on p.payment_method=pm.payment_method_id