OR how-to

J

JohnB

I would like to do what is logically shown below but, the syntax is
incorrect. What would be the correct syntax?

SELECT Products.ProductName, Products.ProductStock
FROM Products
WHERE Products.ProductImage1 Is Null
OR
WHERE Products.ProductImage2 Is Null;

TIA
 
F

fredg

I would like to do what is logically shown below but, the syntax is
incorrect. What would be the correct syntax?

SELECT Products.ProductName, Products.ProductStock
FROM Products
WHERE Products.ProductImage1 Is Null
OR
WHERE Products.ProductImage2 Is Null;

TIA

Close.... Too many where's.

WHERE Products.ProductImage1 Is Null OR Products.ProductImage2 Is
Null;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top