DRAFT

Omnidex SQL: SELECT WHERE Clause

QuickLinks	Statements	Functions	OdxSQL

See Also:	SELECT Statement	FROM clause	GROUP BY clause	ORDER BY clause

Description

The WHERE clause can be used to specify both criteria and table join information.

  WHERE [ criteria_list ]
        [ EXISTS (subquery) ]
        [ IN (subquery) ]

select * from trans_table where state = 'CA';