Ask how to write a SQL statement, joint query

A table has fields
ID title
1 DDDDDDD
2 ccccccc
3 HHHHHHHH

There are fields
ID AID STATUS
120
211
321
430
510
in

B table.

ID in table A corresponds to AID in table B

I need to use a federated query to find all the data in table An and correspond to the latest table B records.

After working on

for a long time, I can only find the corresponding first record in Table B, not the latest record. For example, if the record with ID 1 in table An and the record with ID 2 in table B, what I need to find is the record with 5.
ask for advice!

Mysql
Mar.24,2021
The idea of

@ jzoom is correct, but the field of the max function is not correct. Let me add: 

select a.*, b.*
from a join (select aid, max(id) as max_id from b group by aid) b1 on a.id = b1.aid
       join b on b1.max_id = b.id

this is an obvious subquery
select a. ID. Aid from a join (select max (aid) as aid from b group by aid) b on a.id=b.aid
other fields please add

if the data in table B corresponds to only one piece of data in table A, it is OK to add a sort. 

select a.*, b.* from b left join a on a.id = b.aid order by b.id DESC

Previous: Vue install sass

Next: What kind of problem is solved by using a div with height 0 and both border-top and border-bottom set as a border?

css mysql arrays josn react html typescript webpack npm sass R objective-c .net sql-server jquery python-3.x angularjs django angular excel regex iphone ajax linux xml pandas vba spring database wordpress string wpf xcode windows bash postgresql oracle multithreading eclipse list firebase algorithm macos forms image scala visual-studio azure bootstrap spring-boot react-native python-2.7 docker performance function winforms matlab powershell apache dataframe api sqlite numpy rest shell selenium flutter dart maven loops qt swing android-studio csv express file class tensorflow sorting codeigniter perl
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1becc8f-31379.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1becc8f-31379.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?