0 Replies Latest reply on Apr 24, 2012 10:40 AM by user9950484

    How to retrive the result by query

    user9950484
      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