「SQL」inner joinで三つのテーブルを結合してデータを抽出する

2021年8月22日

書式
select 項目 from テーブルA
inner join テーブルB
on 条件式
inner join テーブルC
on 条件式

使用例

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
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

SQL

Posted by arkgame