sql 语句中where条件和jion on条件的区别
与有很大的差别,请注意!
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
条件全部放到join的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)
连接和条件分开。
感谢阅读,希望能帮助到大家,谢谢大家对本站的支持!