mysql - 如何组合两个简单的sql查询

Question

我有以下 sql 查询:

//Get id
SELECT id from magazine where name = 'Web Designer'


SELECT avatar from person where newsletter = 1 and id in
(
 SELECT person_id as id FROM person_magazine WHERE magazine_id = 9 //use id from previous query
)

如何将它们结合起来，这样我就不必运行两个查询？

Answer 1

我认为您需要了解联接。以下是您真正想要的查询:

SELECT p.avatar
from person p join
     person_magazine pm
     on pm.person_id = p.id join
     magazine m
     on pm.magazine_id = m.id
where p.newsletter = 1 and m.name = 'Web Designer'