Join(5 Type Join)

The JOIN clause is used to combine rows in two or more tables based on the common columns in these tables. In openGauss, the JOIN clause has five types of join operations. CROSS JOIN INNER JOIN LEFT OUTER JOIN RIGHT OUTER JOIN FULL OUTER JOIN ...