SQL Joins Clause

The SQL JOIN clause used to combines OR join rows from two or more tables. The JOIN clause creates a set of rows in a temporary table.

SQL JOIN's Syntax

SELECT Table_1.T1Column_1, Table_2.T2Column_1
FROM Table_1
INNER JOIN Table_2 ON Table_1.T2Column_2=Table_2;

Different Types of JOIN's in SQL

Four basic types of SQL JOIN's:

  • INNER JOIN
  • LEFT JOIN or LEFT OUTER JOIN
  • RIGHT JOIN or RIGHT OUTER JOIN
  • FULL JOIN or FULL OUTER JOIN

See below-mentioned image for more understanding

types of SQL joins

EQUI JOIN

The SQL EQUI JOIN is a simple SQL JOIN used to the equal sign (=) as the comparison operator for the condition.

  • QL OUTER JOIN and SQL INNER JOIN both are the EQUI JOIN.

NON EQUI JOIN

The SQL NON EQUI JOIN is a JOIN used to the comparison operator other than the equal sign like >, <, >=, <= with the condition.

Policy

GDATAMART.COM is optimized for learning & job information; The users try to improve your knowledge and practical experience through this site but we cannot warrant full correctness of all content... Learn More → | Sitemap →

© 2020 GDATAMART | All Rights Reserved