Jump to content

peted

Members
  • Content Count

    1
  • Joined

  • Last visited

Community Reputation

0 Neutral

About peted

  • Rank
    Newbie
  1. peted

    SQl Statment help

    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.
×
×
  • Create New...