<div>
When you use INNER JOIN, you have to provide the ON clause for your query, which is equivalent to provide WHERE clause.<br />
<br />
i.e.<br />
<br />
SELECT Column1,Column2 FROM Tbl1 INNER JOIN Tbl2<br />
ON Tbl1.MyId = Tbl2.MyId<br />
<br />
It is equivalent to<br />
<br />
SELECT Column1,Column2 FROM Tbl1, Tbl2<br />
WHERE Tbl1.MyId = Tbl2.MyId
</div>


When you use INNER JOIN, you have to provide the ON clause for your query, which is equivalent to provide WHERE clause.

i.e.

SELECT Column1,Column2 FROM Tbl1 INNER JOIN Tbl2
ON Tbl1.MyId = Tbl2.MyId

It is equivalent to

SELECT Column1,Column2 FROM Tbl1, Tbl2
WHERE Tbl1.MyId = Tbl2.MyId

<div>
i undertstand, but what the mean?<br />
<b>Logical separation between filtering for purposes of join and filtering results in WHERE</b>
</div>


i undertstand, but what the mean?
Logical separation between filtering for purposes of join and filtering results in WHERE

<div>
<div class="content wysiwyg-content">
Hi experts i am reading about:Understanding Inner Joins<br />
but i do not understand:<br />
Why filter in ON clause?<br />
<b>Logical separation between filtering for purposes of join and filtering results in WHERE</b><br />
<br />
can explain me with an example, like hands on lab
</div>
</div>


Hi experts i am reading about:Understanding Inner Joins
but i do not understand:
Why filter in ON clause?
Logical separation between filtering for purposes of join and filtering results in WHERE

can explain me with an example, like hands on lab

sql server 2012 - Understanding Inner Joins

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.