0 Replies Latest reply: Jun 20, 2011 3:05 PM by user13001889 RSS

    neeed help to write a case statement

    user13001889
      I want to write a case statement such that

      i have four name sunny,katie,linda,scott in which sunny is the manager
      the rek is that under sunny if katie,linds scott falls then i need to show "yes" in coloumn other wise "no"


      like

      case when cn1.sunny=cn2 in(katie,linda,scott) then 'y' else 'n'

      Edited by: user13001889 on Jun 20, 2011 1:04 PM