Question: what is the difference between an inner and outer join?
Answer: Inner and outer joins are combine rows from two or more tables into a single result using a join condition. The join condition specifies how columns from each table are matched to one another. ... Inner joins don't include non-matching rows; whereas, outer joins do include them.