TurboSQL Guide

FROM

Previous  Top  Next


Specifies the tables from which a SELECT statement retrieves data.

FROM table_reference [, table_reference...]

Description

Use a FROM clause to specify the table or tables from which a SELECT statement retrieves data. The value for a FROM clause is a comma-separated list of table names. Specified table names must follow TurboSQL naming conventions for tables. The following examples show different ways, how the from clause can look like:

SELECT *
FROM "customer.dat"

SELECT * FROM
customer, orders

SELECT * FROM
customer JOIN orders ON orders.CustNo = customer.CustNo

Applicability

SELECT