「SQL」inner joinで三つのテーブルを結合してデータを抽出する
書式
select 項目 from テーブルA
inner join テーブルB
on 条件式
inner join テーブルC
on 条件式
使用例
select
ta.orderid
, tb.customername
, tc.shippername
from
(
(
orders ta
inner join customers tb
on ta.customerid = tb.customerid
)
inner join shippers tc
on ta.shipperid = tc.shipperid
)
where tb.customername like 'Han%'
select
ta.orderid
, tb.customername
, tc.shippername
from
(
(
orders ta
inner join customers tb
on ta.customerid = tb.customerid
)
inner join shippers tc
on ta.shipperid = tc.shipperid
)
where tb.customername like 'Han%'
select ta.orderid , tb.customername , tc.shippername from ( ( orders ta inner join customers tb on ta.customerid = tb.customerid ) inner join shippers tc on ta.shipperid = tc.shipperid ) where tb.customername like 'Han%'
結果
OrderID | CustomerName | ShipperName |
---|---|---|
10250 | Hanari Carnes | United Package |
10253 | Hanari Carnes | United Package |