What is the difference between inner and outer join?

Technology CommunityCategory: SQLWhat is the difference between inner and outer join?
VietMX Staff asked 3 years ago
  • Inner join returns rows when there is at least one match in both tables
  • Outer join will return matching rows from both tables as well as any unmatched rows from one or both the tables