A table has fields
ID title
1 DDDDDDD
2 ccccccc
3 HHHHHHHH
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!