WHERE AND OR

[nathan cobb]

Hello,

I've been struggling to understand how to achieve a certain AND/OR logic.

SELECT id FROM table1 WHERE column1 = 1 AND column2 = 7;

The above query will select the id if column1 and column2 both prove true, and not if column1 does and column2 not.

If I use an OR clause it will stop once column1 proves true and not select using column2 as a condition.

How would I modify this query so that it selects data where column1 is true and where column2 is true without both having to prove true?

I'm sure this is an obvious one. Thanks