Question: what is the difference between left and inner join?
Answer: 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.