sql 語(yǔ)句中where條件和jion on條件的區(qū)別
與有很大的差別，請(qǐng)注意！
SELECT TBL_SchemaDetail.MaterialNo, TBL_StockMaterial.SalePrice FROM TBL_StockMaterial RIGHT OUTER JOIN TBL_SchemaDetail ON TBL_StockMaterial.MaterialNo = TBL_SchemaDetail.MaterialNo AND TBL_SchemaDetail.SchemaNo = '7411' AND TBL_StockMaterial.SalePrice = 0
條件全部放到j(luò)oin的on中。
SELECT TBL_SchemaDetail.MaterialNo, TBL_StockMaterial.SalePrice FROM TBL_StockMaterial RIGHT OUTER JOIN TBL_SchemaDetail ON TBL_StockMaterial.MaterialNo = TBL_SchemaDetail.MaterialNo WHERE (TBL_SchemaDetail.SchemaNo = '7411') AND (TBL_StockMaterial.SalePrice = 0)
連接和條件分開(kāi)。
感謝閱讀，希望能幫助到大家，謝謝大家對(duì)本站的支持！
新聞熱點(diǎn)
疑難解答
圖片精選
