MapInfo Products KnowledgeBase

Product: MapBasic
Version: 4.x\5.x\6.x
Platform: Not Platform Related
Category: Selections and Finds

Summary:
Select Statement - Description.

Question:
How is the Select statement in MapBasic used?

Answer:
The best way to understand Select statements is to open the MapBasic window in MapInfo and run a few sample selections. This will display the proper syntax of the statement.

Select expression_list
From table_name [,...] Where expression_group
Into results_table
Group By column_list
Order By column_list

The result of any Select statement is a temporary table that, by default, may be referenced by one of two names: Selection or Query#. The table Selection will change with each new query ( Note: see Using the Noselect option in a query-->). The table Query# is a snapshot of the selection and can be accessed at a later time. The Into table option can be included in the statement and effectively changes the name of the Query# table.

Last Modified: 02/21/2001 05:08:41 PM
Document URL: http://testdrive.mapinfo.com/techsupp/miprod.nsf/kbase_by_product/7F4E82A7FA2D82C68525628D005F7F35

Select Statement - Description.^7F4E82A7FA2D82C68525628D005F7F35^Y