Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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