latest status of PID

[#1]

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

[sunny_talwar]

Try to do this in script or front end?

[#3]

Yeah can I get any of it but i need output asap please