Databases Reference
In-Depth Information
We have selected two tables, but have not yet chosen any columns from the
books
table, so this table is not mentioned in the generated query.
Criteria
In the
Criteria
box, line, we can enter a condition (respecting the SQL
WHERE
clause's
syntax) for each of the corresponding columns. By default, we have two criteria
rows. To find all authors with
Smith
in their name, we use a
LIKE
criterion -
LIKE
'%SMITH%'
- and click
Update Query
:
Search WWH ::
Custom Search