Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Table1:
PID | Name | Status | Date | AID |
1 | XXX | Open | 10/11/2014 | 1 |
1 | YYY | Closed | 1/3/2015 | 3 |
1 | ZZZ | Closed | 12/1/2016 | 4 |
1 | MMM | - | 19/1/2016 | 5 |
I have displayed the latest entry in Table2:
Table2:
PID | Name | Status | Date | AID |
1 | MMM | - | 19/1/2016 | 5 |
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:
PID | Name | Status | Date | AID |
1 | MMM | Closed | 19/1/2016 | 5 |
Try to do this in script or front end?
Yeah can I get any of it but i need output asap please