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>][,…]
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