SELECT with multiple conditions

[Tonatiuh]

The SELECT statament could include a condition (after WHERE clause) to filter the records returned to the recordset.

Example:

SELECT * FROM table WHERE field1='XYZ'

In this case the 'XYZ' is the filter for the field1.

How can I write the statament to fileter for two fields. (field1 and field2)??

Any idea will be appreciated.

Thanks!

Ulises

[JHausmann]

"AND" works.

SELECT * FROM table WHERE field1='XYZ' AND field2='ABC'

-Azzmodan

[Tonatiuh]

Thanks! :-)

Ulises