case语句，在mysql中取相同状态的匹配

Question

我有2个表，一个表有状态，另一个表有标记和id。

table1

<表类> id 版本名称tbody><<tr>10ram21ram32ram43ram

Test this:

SELECT t1.*
FROM table1 t1
JOIN table2 t2 ON t1.id = t2.sid AND t1.name = t2.name
WHERE t2.status = 'Pass'
ORDER BY t1.versin DESC LIMIT 1

https://dbfiddle.uk/?rdbms=mysql_8.0&小提琴= e5c80834ad2662a47254c777adba1355