Do do we need an ON clause when using a LEFT JOIN?

Yes, to introduce a condition for matching rowsNo, since the LEFT JOIN selects all items anyway

Yes, to introduce a condition for matching rows.