Description and difference between SQL where and jion on conditions, wherejion

Description and difference between SQL where and jion on conditions, wherejion

Differences between the where and jion on conditions in SQL statements

There is a big difference. Please note!

SELECT region, TBL_StockMaterial.SalePrice FROM TBL_StockMaterial right outer join TBL_SchemaDetail ON TBL_StockMaterial.MaterialNo = region AND region = '2016' AND TBL_StockMaterial.SalePrice =

All the conditions are placed in the join on.

SELECT region, TBL_StockMaterial.SalePrice FROM TBL_StockMaterial right outer join TBL_SchemaDetail ON region = region WHERE (region = '20170101') AND (TBL_StockMaterial.SalePrice = 0)

The connection and condition are separated.

Thank you for reading this article. I hope it will help you. Thank you for your support for this site!