5 Replies Latest reply on Jul 29, 2008 3:28 AM by musicmp3

    Kind of query on an array

    aubweb
      Hi,

      I have an array like this :

      DATA | YEAR | SCENARIO | JAN | FEB | MAR | ....
      data1 2008 1 120 101 109
      data2 2008 2 120 105 104
      data3 2007 1 100 108 111
      data4 2008 1 124 101 116

      and I want to search something like we do with a query but on an array

      SELECT JAN
      FROM myArray
      WHERE
      YEAR = 2008
      AND SCENARIO = 1
      AND DATA= data3

      is it possible ? and how to do it ?

      Thanks !