# FROM

> For the complete documentation index, see [llms.txt](https://docs.redpanda.com/llms.txt). Component-specific: [cloud-data-platform-full.txt](https://docs.redpanda.com/cloud-data-platform-full.txt)

---
title: FROM
latest-operator-version: v26.1.4
latest-console-tag: v3.7.3
latest-connect-version: 4.93.0
latest-redpanda-tag: v26.1.9
docname: sql/sql-clauses/from/index
page-component-name: cloud-data-platform
page-version: master
page-component-version: master
page-component-title: Cloud
page-relative-src-path: sql/sql-clauses/from/index.adoc
page-edit-url: https://github.com/redpanda-data/cloud-docs/edit/main/modules/reference/pages/sql/sql-clauses/from/index.adoc
description: Reference for the FROM clause and JOIN variants in Redpanda SQL.
page-git-created-date: "2026-05-26"
page-git-modified-date: "2026-05-26"
---

<!-- Source: https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-clauses/from.md -->

-   [FROM](from/)

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

-   [JOIN](join/)

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

-   [LEFT JOIN](left-join/)

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

-   [OUTER JOIN](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](right-join/)

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