peted
-
Posts
1 -
Joined
-
Last visited
peted's Achievements
Newbie (1/7)
0
Reputation
-
peted joined the community
-
id name status a b c e F 1 Jon open 1 1 2 2 2 Jane open 2 2 2 1 1 3 Billy open 2 2 2 4 Mary closed 2 2 2 5 James Closed 1 2 2 2 6 Jimmy Closed 2 1 Hi, I need some help with some SQL. I need a statement that select a row that have a status of open or if it is closed, one of the columns A-F have a number 1 in it. So in the example table above I would need rows 1, 2, 3 selected as they are open and rows 5 & 6 as they are closed but have a 1 in the A-F columns. Hope this makes sense. Any help would be great.