sqlite join
lazarus / 16-Databases

----------------------------------------------------------------------
michoux · 2020-07-12 07:18

hello I have 2 sqlite datbases.
is there a way to select join 2 tables each from different database?

----------------------------------------------------------------------
madref · 2020-07-12 08:21

If you search with Google on these keywords: sql join 2 databases as 1
you get a nice range of answers.
make copies of your databases and enjoy the rush that's called
EXPERIMENT.


Good luck

----------------------------------------------------------------------
rvk · 2020-07-12 08:50

Might want to redo your google search like
sqlite join 2 databases as 1

Because every database (if at all possible) does this in a different
way.

(First hit will give correct result for sqlite)

----------------------------------------------------------------------
Zvoni · 2020-07-12 12:27

Or read the official docs: https://www.sqlite.org/lang_attach.html

Here as another link
https://www.sqlitetutorial.net/sqlite-attach-database/