difference between inner join and where clause in sql?
INNER JOIN ON vs WHERE clause The WHERE clause, what is done is that all records that match the WHERE condition are included in the result set but an INNER JOIN is that, data not matching the JOIN condition is excluded from the result set.