0 Replies Latest reply: Apr 24, 2012 5:40 AM by 758606 RSS

    How to retrive the result by query

    758606
      i have a table having following coulmn

      EMP_CODE EMP_FLAG EMP_CAT EMP_CAT2
      111 1 125 123
      112 2 124 111
      113 2 154 154




      Here the emp_flag have only 2 values 1 or 2 if the emp_flag contains 1 then the result should be value of emp_cat field else if the emp_flad have value 2 then the value should come from emp_cat2 field


      so please suggest the query for this....

      thanks

      Edited by: user9950484 on Apr 24, 2012 3:38 AM