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.
SQl Statment help
in SQL
Posted
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.