Understanding Joins in SQL: A Deep Dive into Left and Right Joins with Cross Reference Tables