#left outer

SQL join and left outer join: why are the results differents? [duplicate]

This question already has an answer here:

Difference between inner and outer join 13 answers

I have a table partenaire. A partenaire may have one or more addresses. And of course one address may “belong” to more than one partenaire. So I have 3 tables: partenaire, partenaire_adresse and adresse. The address has only one town (villein French) so I have a foreign…