For the below statement :-
"They simply are not the same and would give different results depending on what you want back. "
Does it refer with respect to 'INNER JOIN' and 'JOIN' ? or
does it refer to 'LEFT OUTER JOIN' and 'RIGHT OUTER JOIN ' here
The *left outer join* preserves unmatched rows from the left table but discards unmatched rows from the right table.
I bet you figured out how the right outer join behaves. Right! The *right outer join* preserves unmatched rows from the right table but
discards unmatched rows from the left table.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.