Click or drag to resize

Select syntax

Field selection:

select [table.]<field>[,[table.]<field>][,…]/count([field])

 

Tables with no aliasing:

from <tablename>[,<tablename>][,…]

 

Where-clause:

<field> <operator><field/value> [logic operator]

where <operator> can be: <, >, =,  !=, *=,  <=,  >=,  in, like,  ( ),

and [logic operator]: AND, OR, &&, ||.

 

Order by:

[asc/des][table]<field>[,[asc/des][table]<field>][,…]

 

  

For example:

SELECT category_id, name, registered FROM category WHERE updated >= '2007.06.01'

Returns a list of categories which have been modified since 1st of June 2007.

Up: OLE-DB Provider   Prev: List of Views   Next: Update syntax          Edit