say you are asked to provide/describe/answer a question about the difference between Inner Join and Left Join on SQL queries.
Most people are tempted to describe both joins, i.e.
inner join shows rows with matching keys from both tables,
while left join shows all rows with keys from the left table, and 'tacks on' matching keys from the right table, leaving left table rows without matching keys as is.
Well, the answer above does not really touch on the DIFFERENCE. It describes both situations, leaving the asker to surmise the difference.
Is it possible, to state the actual difference as succintly and informatively as possible, without merely restating what each join does? |
