This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:sql:statements:select:home [2009/12/04 21:03] tdo |
dev:sql:statements:select:home [2012/10/26 14:28] (current) |
||
|---|---|---|---|
| Line 3: | Line 3: | ||
| ====== Omnidex SQL SELECT ====== | ====== Omnidex SQL SELECT ====== | ||
| {{page>:sql_bar&nofooter&noeditbtn}} | {{page>:sql_bar&nofooter&noeditbtn}} | ||
| + | ===== Description ===== | ||
| + | The Omnidex SQL Select statement is the primary statement used to query records on Omnidex enhanced data. | ||
| + | |||
| - | ===== Description ===== | ||
| ===== Syntax ===== | ===== Syntax ===== | ||
| Line 53: | Line 55: | ||
| ORDER BY [column | position ] [, column | position ] | ORDER BY [column | position ] [, column | position ] | ||
| </code> | </code> | ||
| - | |||
| ===== Discussion ===== | ===== Discussion ===== | ||
| Line 59: | Line 60: | ||
| * All columns for the named tables using a syntax of: | * All columns for the named tables using a syntax of: | ||
| - | [[[environment.]database.]table.]* | + | [ [ [ environment. ] database. ] table. ] * |
| column A column, optionally qualified by a table, optionally with an alias | column A column, optionally qualified by a table, optionally with an alias | ||