OR how-to

  • Thread starter Thread starter JohnB
  • Start date Start date
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
 
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
Click to expand...

Close.... Too many where's.

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