---
schema_version: "1"
id: 27c6e3b30b957f6cf0f052c8b3e70b9009a263921a506e26f66cfbb5ed7d5531
title: FROM Clause
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_sql/guides/bi-sql-from.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-from.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 8f91dbc55f1ad4468969f223a753c69cecb800e3988d96dbe358581a58778bd9
products:
  - SQL for Analytics Developer Guide
  - analytics
---

# FROM Clause

The `FROM` clause defines which table or table function to query. CRM Analytics SQL supports using `FROM` with a single table only. You can’t select from multiple tables.

CRM Analytics SQL supports the following table functions.

- **[FILL](https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-fill.md)**


    Use the `FILL()` table function to fill in any gaps in date fields. By specifying the date fields to check, `FILL()` creates rows that contain the missing month, day, week, quarter, or year and null data. Use it with `TIMESERIES()` to forecast future results when there are gaps in input data.

- **[TIMESERIES](https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-timeseries.md)**


    Use the `TIMESERIES()` table function to predict future values based on existing ones tracked over time. Optionally choose a prediction model, confidence interval, and seasonality among other parameters.