SQL

Internal

• Relational Databases
• PrestoDB
• PostgreSQL

JOIN

The SQL JOIN clause is used to combine rows from two or more tables, based on a related column between them.

INNER JOIN

Return records that have matching values in both tables.

LEFT (OUTER) JOIN

Return all records from the left table and the matching records from the right table.

RIGHT (OUTER) JOIN

Return all records from the right table and the matching records from the left table.

FULL (OUTER) JOIN

Returns all records when there is a match in either left or right table.