Q:

inner join check all the rows?

Table1
id name
1  test
2  test2
3  test3
4  test4

Table2
id total
1   40%
4   80%

If we use inner join for these table,
Is join checking all the rows and finally return matched row?

A:

Short answer yes. This will fetch for example (join table2 using(id)) test 40% and test4 80%)

