Search your topic here

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.
 






LEAVE A REPLY