mysql - 我该如何完成这个查询？

Question

select * from workers where id = uid and age = uage`   -- sql1
select uid,uage from users where uage>20`              -- sql2

我想用sql2作为sql1的条件，即uid和uage在sql1 来自sql2。

Answer 1

您可以连接两个表:

SELECT w.*
FROM workers w
INNER JOIN users u
ON w.id = u.uid AND w.age = u.uage
WHERE u.uage > 20