The following code shows a summary of the main clauses of the SELECT - SQL Command:

	Copy Code
SELECT Select_List FROM Table_List ...[WITH (BUFFERING = lExpr)] [WHERE Conditions] [GROUP BY Column_List] [HAVING Conditions] [UNION Clause] [ORDER BY Column_List] [INTO Clause | TO Clause ] [Additional_Display_Options]

For more information about a particular clause of the SQL SELECT command, see the following topics:

• SELECT Clause

• FROM Clause

• SELECT - SQL Command - WITH Clause

• SELECT - SQL Command - WHERE Clause

• GROUP BY Clause

• HAVING Clause

• ORDER BY Clause

• INTO or TO Clause

• Additional Display Options

You can use the UNION clause to simulate an outer join. You can specify multiple UNION clauses; there is no limit on the number of UNION clauses per SELECT statement.

Visual FoxPro supports implicit data type conversion for data types that support it. For more information as well as rules and considerations concerning UNION clauses, see Considerations for SQL SELECT Statements.

Reference

Other Resources