Using T-SQL code, I replicate examples show in the SQL Join Conceptual Examples (Lecture) video. The examples are small scale to promote understanding of join types and how they differ. The video covers:
1. INNER, FULL, and LEFT/RIGHT joins.
2. Tables aliases and column ambiguity.
3. Using the * in a select list with joined tables.
4. How to return unmatched records.
5. Re-writing a LEFT join as a RIGHT join.