SQL join

SQL JOIN

A SQL Join statement is used to combine data or rows from two or more tables based on a common field between them. Different types of Joins are:

  1. INNER JOIN: Select records that have matching values in both tables.
  2. LEFT JOIN: Select records from the first (left-most) table with matching right table records.
  3. RIGHT JOIN: Select records from the second (right-most) table with matching left table records.
  4. FULL JOIN: Selects all records that match either left or right table records.
 


More topics from DBMS to read:

References:

  1. Korth, Silbertz,Sudarshan, “Fundamental of Database System”, McGraw Hill
  2. Atul Kahate , “ Introduction to Database Management System”, Pearson Educations