SELECT *
FROM STORE
,MATERIAL
,STOREBIN
,VENDOR
,MATERIALPRICE
,SD
WHERE STOREBIN.STOREBINID( ) = SD.STOREBINID
AND SD.VENDORID = VENDOR.VENDORID( )
AND MATERIAL.MATERIALID = MATERIALPRICE.MATERIALID( )
AND STORE.STOREID = SD.STOREID
我在這里有這個簡單的查詢，但我想將 ( ) 符號更改為連接，這怎么可能？我剛在想：
RIGHT JOIN SD ON STOREBIN.STOREBINID = SD.STOREBINID
LEFT JOIN VENDOR ON VENDOR.VENDORID = SD.VENDORID
LEFT JOIN MATERIALPRICE ON MATERIALPRICE.MATERIAID = MATERIAL.MATERIALID
WHERE STORE.STOREID = SD.STOREID
但這似乎不太對，因為我需要將每張桌子加入不同的桌子。
uj5u.com熱心網友回復：
這將是等效的（如果我們還添加您提到的其他標準）：
FROM
SD
INNER JOIN STORE as S
on S.STOREID = SD.STOREID
INNER JOIN MATERIAL as M
ON M.MATERIALID = SD.MATERIALID
LEFT JOIN STOREBIN as SB
ON SB.STOREBINID = SD.STOREBINID
LEFT JOIN VENDOR as V
ON V.VENDORID = SD.VENDORID
LEFT JOIN MATERIALPRICE as MP
ON MP.MATERIALID = M.MATERIALID
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/439859.html
上一篇：在SQL中基于兩個日期運行Sum