Databases Reference
In-Depth Information
We have selected two tables, but have not yet chosen any column from the
book
table. Hence, this table is not mentioned in the generated query.
Adding conditions to the criteria box
In the
Criteria
box, 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 the authors with
Smith
in their names, we use a
LIKE
criterion
(
LIKE
'%SMITH%'
) and click on
Update
Query
.
Search WWH ::
Custom Search