Tag: Sql Join

Who Loves Whom?

sql join, join, join sql, sql join 3 tables, sql full join, sql left outer join, sql multiple joins, outer join in sql, inner join example, natural join sql, self join in sql
Just in time for Valentine’s Day, we discover which of Gary and Sara’s friends are in love – and how to use the SQL JOIN statement to work with data in multiple tables! Did you know SQL is a matchmaker? That’s right; it loves to make data couples by linking information from two (or more!) tables using the JOIN statement. However, many SQL rookies run into problems using JOIN. So let’s go to a party and learn how to use JOIN the right way!