Lazarus

Programming => Databases => Topic started by: michoux on July 12, 2020, 09:18:58 am

Title: sqlite join
Post by: michoux on July 12, 2020, 09:18:58 am

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

Title: Re: sqlite join
Post by: madref on July 12, 2020, 10:21:16 am

If you search with Google on these keywords: sql join 2 databases as 1 (https://www.google.nl/search?source=hp&ei=UscKX_yxLIPolwS_pYe4Aw&q=sql+join+2+databases+as+1&oq=sql+join+2+databases+as+1&gs_lcp=CgZwc3ktYWIQAzIICCEQFhAdEB4yCAghEBYQHRAeMggIIRAWEB0QHjoICAAQsQMQgwE6BQgAELEDOgIIADoGCAAQFhAeUNQNWPd5YMSFAWgAcAB4AIABtQOIAfQOkgEKMjMuMC4xLjAuMZgBAKABAaoBB2d3cy13aXo&sclient=psy-ab&ved=0ahUKEwj8ori_o8fqAhUD9IUKHb_SATcQ4dUDCAo&uact=5) you get a nice range of answers.
make copies of your databases and enjoy the rush that's called EXPERIMENT.


Good luck

Title: Re: sqlite join
Post by: rvk on July 12, 2020, 10:50:26 am

Might want to redo your google search like
sqlite join 2 databases as 1 (https://www.google.nl/search?q=sqlite+join+2+databases+as+1&oq=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)

Title: Re: sqlite join
Post by: Zvoni on July 12, 2020, 02:27:25 pm

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

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