Question

how do you apply multiple criteria to the same table ? explain with an example​

Answer 1

Explanation:

The cursor moves down one line in SQL view. Types Form, followed by the name of the first of the tables you want in the query. Press ENTER. If you want to specify a criterion for a field from the first table, table WHERE, followed by the field name, a comparison operator (usually, an equal sign (=)), and the criterion.