4 Replies Latest reply: Jan 30, 2015 8:52 AM by Veeranjaneyulu Pabbineedi RSS

    Need Help in Showing the  data which should satisfy two conditions.

    Veeranjaneyulu Pabbineedi

      HI All,

      I have the data as BELOW :

       

      EmpNameCoreTrainingIndividual training statustrn_code
      EMP1CORECOMPLIANTT1
      EMP1DELINQUENTT2
      EMP1COREINPROGRESST3
      EMP2CORECOMPLIANTT4
      EMP2COREDELINQUENTT5
      EMP2DELINQUENTT6
      EMP3-ASSIGNMENT IN PROGRESS-
      EMP4-ASSIGNMENT IN PROGRESS-

       

      In the output i have to show the data only of those employees who are assigned Core Trainings and for whom no trainings are assigned at all.

      Here the output should be   which are highlighted above in red color.

       

      Can any one please help me.

       

       

       

      Thanks,

      Anjee