Help Center> Data Warehouse Service> Tool Guide> DSC - SQL Syntax Migration Tool> SQL Syntax Migration Reference> Oracle Syntax Migration (GaussDB A)> Outer Join
Outer Join
This section describes the migration syntax of Oracle Outer Join. The migration syntax decides how the keywords/features are migrated.
An outer join returns all rows that satisfy the join condition. In addition, it returns rows from one table for which no rows from the other satisfy the join condition. In Oracle,
- Left outer join of tables A and B returns all rows from A and rows that satisfy the join condition by applying the outer join operator (+) to all columns of B in the WHERE conditions.
- Right outer join of tables A and B returns all rows from B and rows that satisfy the join condition by applying the outer join operator (+) to all columns of A in the WHERE condition.
GaussDB(DWS) does not support outer join operator (+). The function of this operation is fulfilled using LEFT OUTER JOIN and RIGHT OUTER JOIN keywords.
Figure 1 Input - Outer Join
Figure 2 Output - Outer Join
Parent topic: Oracle Syntax Migration (GaussDB A)
Last Article: Pseudo Columns
Next Article: OUTER QUERY (+)
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.