我知道這對你們中的一些人來說是一個非常基本的問題，但我真的很掙扎。
我必須得到正在攀登特定山峰（富士山）的人的姓名。
到目前為止我已經嘗試過：
SELECT climber.first_name||' is going to climb '||mountain.mountain_name FROM climber
INNER JOIN mountain ON mountain.mountain_id=climbing.mountain
INNER JOIN climbing ON climbing.climbing_id=climbing_participants.climbing_id
INNER JOIN climbing_participants ON climbing_participants.climber_id=climber.climber_id;
uj5u.com熱心網友回復：
SELECT climber.first_name||' is going to climb '||mountain.mountain_name
FROM climber
INNER JOIN climbing_participants ON climbing_participants.climber_id=climber.climber_id
INNER JOIN climbing ON climbing.climbing_id=climbing_participants.climbing_id
INNER JOIN mountain ON mountain.mountain_id=climbing.mountain
轉載請註明出處，本文鏈接：https://www.uj5u.com/ruanti/435457.html
上一篇：如何優化分層查詢