Help with query that needs 2 WHERES

[heldenbrau]

I am trying to do the following query, but it produces an error, which I expect.

 

SELECT * FROM newgems WHERE cut='10 Hearts & Arrows' OR cut='8 Hearts & Arrows' WHERE colour='Lavender' OR colour='Light Champagne' OR colour='White' 

 

What do I use instead of WHERE?  Because if I use AND then it selects everything in White, not just '10 hearts & arrows' and '8 hearts & arrows'.  It needs to select only white, lavender or light champagne gemstones that are 8 or 10 hearts and arrows cut.

[ManiacDan]

Wrap your OR clauses in parens:

SELECT * FROM newgems WHERE (cut='10 Hearts & Arrows' OR cut='8 Hearts & Arrows') AND (colour='Lavender' OR colour='Light Champagne' OR colour='White')

-Dan

[heldenbrau]

Thanks again