mysql - 如何组合两个 select 和两个 where 子句？

Question

表一:

StudentId,  StudentName,  School
1           Sam            ABC

表二:

StudentCity  StudentId
Paris         1
mexico        2

答案应该是“巴黎”，因为 StudentId 是 1

select StudentCity 
from TWO
where StudentId = (select StudentId from ONE where StudentName="SAM"); 

请给我建议 sql 查询。

Answer 1

select StudentCity from TWO 
inner join ONE on ONE.StudentId = TWO.StudentId
where ONE.StudentName= "SAM"