2 Replies Latest reply: Jan 21, 2016 1:46 PM by reddy r RSS

    latest status of PID

    reddy r

      Table1:

         

      PIDNameStatusDateAID
      1XXXOpen10/11/20141
      1YYYClosed1/3/20153
      1ZZZClosed12/1/20164
      1MMM-19/1/20165

       

       

      I have displayed the latest entry in Table2:

      Table2:  

      PIDNameStatusDateAID
      1MMM-19/1/20165

       

      I want to show the latest status of PID which is Closed on 12/1/2016 from Table1

      Help me to get the below output

      Output:

         

      PIDNameStatusDateAID
      1MMMClosed19/1/20165