我寫了一個關聯查詢,關聯條件可以用不同表的欄位來關聯嗎,求大神解答
SELECT a.SHOPID
,b.GOODSID
,nvl(c.QTY,0) as startqty
FROM FR_WHOLESALE a
LEFT JOIN FR_WHOLESALEITEM b ON
a.SHEETID = b.SHEETID
LEFT JOIN FR_SHOPSTOCKDAILY c ON
b.GOODSID = c.GOODSID and a.SHOPID = c.SHOPID
uj5u.com熱心網友回復:
你寫的這個陳述句是報了什么錯么?轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/276353.html
標籤:開發