JOIN clauses

Supported
JOIN
 types include:
INNER
,
LEFT
, and
CROSS
. Unsupported types include:
RIGHT
,
FULL
,
NATURAL
, and
UNION
.
TIP: The database management system (DBMS) on which the query is performed may involve querying limitations.

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