what is difference between inner join and left join in sql?
An SQL JOIN clause is used to combine rows from two or more tables, based on a common field between them. ... INNER JOIN: returns rows when there is a match in both tables. LEFT JOIN: returns all rows from the left table, even if there are no matches in the right table.