So I'm learning SQL and right now I'm working on properly understanding joins. I was wondering if I had the following right:1) Inner Joins are associative and commutative.2) Left Outer Joins (T1 ...

In this SQL Server tip, Arthur Fuller explains the effects of NULLs, and the different results obtained by inner and outer JOINs.