Access SQL 3つ以上の外部結合

Published 2018年2月18日 by devidesu

テーブルのつなぎ方

 --並列
SELECT A.*
FROM (A LEFT JOIN B ON A.BID = B.BID) LEFT JOIN C AS C ON A.CID = C.CID;

 --直列
SELECT A.*
FROM (A LEFT JOIN B ON A.BID = B.BID) LEFT JOIN C AS C ON B.CID = C.CID;

--並列

SELECT A.*

FROM (A LEFT JOIN B ON A.BID = B.BID) LEFT JOIN C AS C ON A.CID = C.CID;

--直列

SELECT A.*

FROM (A LEFT JOIN B ON A.BID = B.BID) LEFT JOIN C AS C ON B.CID = C.CID;