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 20:55] 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 39: | Line 41: | ||
| [ ON table1.linkfield = table2.linkfield ] | [ ON table1.linkfield = table2.linkfield ] | ||
| </code> | </code> | ||
| + | |||
| + | <code SQL> | ||
| WHERE | WHERE | ||
| [ EXISTS (subquery) ] | [ EXISTS (subquery) ] | ||
| [ IN (subquery) ] | [ IN (subquery) ] | ||
| - | + | </code> | |
| - | GROUP BY | + | <code SQL> |
| - | + | GROUP BY group_by_columns | |
| - | HAVING [ left_operand operator subquery ] | + | HAVING [ left_operand operator subquery ] |
| - | [ left_operaand IN (subquery) ] | + | [ left_operaand IN (subquery) ] |
| + | </code> | ||
| + | <code SQL> | ||
| ORDER BY [column | position ] [, column | position ] | ORDER BY [column | position ] [, column | position ] | ||
| + | </code> | ||
| ===== Discussion ===== | ===== Discussion ===== | ||
| Line 54: | 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 | ||