This discussion is archived
0 Replies Latest reply: Apr 24, 2012 3:40 AM by 758606 RSS

How to retrive the result by query

758606 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points