Find a SQL statement about INNER JOIN

cc5092

There is a table association structure as follows

a table

    id fid name time
    01 43 ee 2016-12-22
    02 41 qq 2016-12-22
    03 42 88 2016-12-21
b table
    id aid sj time
   guid 01 1111 2016-12-22
   guid 02 1111 2016-12-24
   guid 03 1111 2016-12-22
   guid 03 1111 2016-12-24
-------------------------------------------------- ----------------
Table a is used to store user information, and table b is a review of user information a.id = b.aid
When I only approve it once, using INNER JOIN to query everything works normally and I get the result I want!
However, after reviewing twice, more than one result is returned. Can I add a condition to the ON of the INNER JOIN to get the most relevant one to get a related data?
--------------------------------------------------
Master please help

everever30

select a1. *
from a a1
inner join b b1 on a1.id = b1.aid
where b1.time = (select max (b2) from b b2 where b1.id = b2.id and b1.aid = b2.aid)

evan_jiang

select top 1 ......... order by b.time desc

everever30

select a1. *
from a a1
inner join b b1 on a1.id = b1.aid
where b1.time = (select max (b2.time) from b b2 where b1.id = b2.id and b1.aid = b2.aid)

cc5092

Can you simply specify a condition in on to achieve this, although the effect can be achieved, is the efficiency too low?
Ha ha