8 Replies Latest reply: Jan 27, 2016 12:19 AM by reddy r RSS

    Latest Value

    reddy r

      T1:  

      PRFIDACIDTime stamp
      100111/10/2013
      100211/11/2013
      100311/12/2013
      100411/13/2014

       

       

      T2:

         

      ACIDTimestampText
      311/12/2013Comment

       

      when am trying to display the latest record by using above tables got the output like below:

        Output:  

      PRFIDACIDTime stampText
      100411/13/2014-

       

      but the expected result is:

      all the values will be showm for the  PRFID from two tables.

       

      PRFIDACIDTime stampText
      100411/13/2014Comment