JOIN clauses

Any kind of joins such as
INNER
,
UNION
,
LEFT
,
RIGHT
,
FULL
,
NATURAL
 and
CROSS
 is supported.
NOTE: Some joins are not fully supported by every DBMS.

Supported functionality

Supported JOIN functionality
Expected behavior
Query to achieve the expected behavior
Combine rows from two tables where DepartmentID matches.

SELECT t1.Name, t2.DepartmentName
FROM TestTable1 AS t1
INNER JOIN TestTable2 AS t2
ON t1.DepartmentID = t2.DepartmentID;
Include all rows from the left table and matching rows from the right table.

SELECT t1.Name, t2.Location
FROM TestTable1 AS t1
LEFT JOIN TestTable2 AS t2
ON t1.DepartmentID = t2.DepartmentID;
Combine every row from the first table with every row from the second table.

SELECT t1.Name, t2.DepartmentName
FROM TestTable1 AS t1
CROSS JOIN TestTable2 AS t2;

Unsupported functionality

  • RIGHT JOIN
  • FULL JOIN
  • NATURAL JOIN
  • UNION JOIN
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal