See Also: | SELECT Statement | FROM clause | GROUP BY clause | ORDER BY clause |
---|
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';