やり方
- Aテーブルを開いていて、file_nameのBテーブルをJoinしたい状況
ATTACH DATABASE file_name AS B;
SELECT * FROM A LEFT JOIN B ON A.f = B.f
参考
https://www.sqlitetutorial.net/sqlite-attach-database/
https://www.sqlitetutorial.net/sqlite-left-join/
More than 1 year has 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