PostgreSQL has many を一行だけ連携する方法
table1 has many table2 の関係で
table2 を最新の１行だけ連携させたい場合のSQL
SELECT *
FROM table1 t1
LEFT JOIN table2 t2 ON t2.id = (
SELECT max(id) FROM table2 t3
WHERE t1.id = t3.table1_id
)
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme
List of users who liked
00