Cloud

FROM

  • FROM

    The FROM clause specifies the tables that a query reads data from.

  • JOIN

    The JOIN clause combines records from two tables based on common fields.

  • LEFT JOIN

    The LEFT JOIN returns all matching records from the left table combined with the right table.

  • OUTER JOIN

    The OUTER JOIN returns all the records from the selected fields between two tables, whether the join condition is met or not.

  • RIGHT JOIN

    The RIGHT JOIN returns all matching records from the right table combined with the left table.