Inner vs. Outer joins

In SQL, what’s the difference between an inner and outer join? Joins are used to combine the data from two tables, with the result being a new, temporary table. The temporary table is created based on column(s) that the two tables share, which represent meaningful column(s) of comparison. The goal is to extract meaningful data … Continue reading Inner vs. Outer joins