A quick SQL question

[damon2003]

Hi, I want to select more than one value from a database based on multiple WHERE conditions. However, I am selecting more than 1 value from the same column and it doesnt work. Its ok if using 2 different columns in where clause

SELECT *
FROM PRODUCTS
WHERE PRODUCTS.KEY_PRODUCT='mmTextfield' AND PRODUCTS.KEY_PRODUCT='mmTextfield1'

[damon2003]

I think I just use 'OR' instead and it works ok