Mysql

INNER JOIN ON vs WHERE clause

INNER JOIN ON vs WHERE clause

Sql
For simplicity presume each applicable fields are NOT NULL You tin bash Choice table1this table2that table2somethingelse FROM table1 table2 Wherever