SQL where条件和jion on条件的详解及区别

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) 

连接和条件分开。

感谢阅读，希望能帮助到大家，谢谢大家对本站的支持！