0 Replies Latest reply on Jun 20, 2011 8:05 PM by user13001889

    neeed help to write a case statement

      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"


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

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