Constraints in Joins

Platform
1

What are the constraints for inner, left outer and right outer joins?

2

Hi @kousalya.jayasankar
Joins are used to combine data from two or more tables based on a specified condition. The constraints for different types of joins, such as inner, left outer, and right outer joins, are as follows:

  1. Inner Join:
  • Constraint: Only rows with matching values in both tables’ join columns are included in the result set.
  • Non-matching rows from either table are excluded from the result.
  • Result set includes only the intersection of data between the tables.
  1. Left Outer Join (or Left Join):
  • Constraint: All rows from the left (or first) table are included in the result set.
  • Non-matching rows from the right (or second) table have NULL values in columns from the right table.
  • Result set includes all data from the left table and only matching data from the right table.
  1. Right Outer Join (or Right Join):
  • Constraint: All rows from the right (or second) table are included in the result set.
  • Non-matching rows from the left (or first) table have NULL values in columns from the left table.
  • Result set includes all data from the right table and only matching data from the left table.