Skip to content

Join

IT Notes → Database → SQL @ December 22, 2020

  • CARTESIAN JOIN is a join of every row of one table to every row of another table.
  • INNER JOIN (sometimes called the “EQUI-JOIN”) is a join that selects only those records from both database tables that have matching values.
  • OUTER JOIN selects all of the records from one database table and only those records in the second table that have matching values in the joined field. In a left outer join, the selected records will include all of the records in the first database table. In a right outer join, the selected records will include all records of the second database table.
  • SELF JOIN which is a table joined to itself.
0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x