This is an old revision of the document!
The WHERE clause can be used to specify both criteria and table join information.
Statement
select * from trans_table where state = 'CA';