Common: Joining Tables — Ryan Moeller learn.common.org

​Syntax (multiple Key Columns)
Dependencies among Tables
Inner Joins
Cross Join
Self Joins
NULL Values
Scalar Function for converting NULL Values (COALESCE(), NULLIF())
Left/Right Outer Join
Left/Right Exception Join (Presenter’s choice)
Full Join Read More