load only the max dates

[0li5a3a]

Hi all,

can someone help me how to  load only the max dates from the below tables:

tab1:

id , parentid, date, newteam

1, 11, 20/11/2018 11:30,  go

1, 11, 20/11/2018 11:31,  go

1, 11, 20/11/2018 11:38,  go

2, 12, 21/11/2018 12:00,new

3, 13, 22/11/2018 12:21, new

tab2:

id, orderdate, team

1, 20/11/2018 11:30, 

2, 20/11/2018 12:00,

3, 21/11/2018 12:00,new

FinalTable:

id,parentid,date,newteam

1, 11, 20/11/2018 11:38,  go

2, 20/11/2018 12:00, new

3, 21/11/2018 12:00,new

What I need to write the logic to be able to display the FianlTable?

Thanks for help

[Frank_Hartmann · Accepted solution]

I dont understand the logic.
Can u give more details?
You want to show only max date per id?
then i would expect this as final table:

id parentid newteam date
1 11 go 20/11/2018 11:38
2 12 new 21/11/2018 12:00
3 13 new 22/11/2018 12:21