Help Center> Data Lake Insight> SQL Syntax Reference> SQL Syntax of Batch Jobs> JOIN> FULL OUTER JOIN
View PDF

FULL OUTER JOIN

Function

Join all records from the right table and the left table and return all joined records. If no joined record is found, NULL will be returned.

Syntax

1
2
 
SELECT attr_expr_list FROM table_reference
  FULL OUTER JOIN table_reference ON join_condition;

Keyword

FULL OUTER JOIN: Matches all records in the left and right tables. If no record is matched, NULL is returned.

Precautions

The to-be-joined table must exist. Otherwise, an error is reported.

Example

To join all records from the right table and the left table and return all joined records, run the following statement. If no joined record is found, NULL will be returned.

1
2
 
SELECT student_info.name, course_info.courseName FROM student_info
  FULL OUTER JOIN course_info ON (student_info.courseId = course_info.courseId);
Parent topic: JOIN