php - 从具有多对多关系的表中检索数据？

Question

现在我如何从 tm_id=10 的表 2 中选择 project_title

完成这项任务的最佳方法是什么？

Answer 1

SELECT t2.project_title FROM table2 AS t2
JOIN table3 AS t3 ON t3.project_id = t2.project_id
WHERE t3.tm_id = 10;