Recent

Author Topic: sqlite join  (Read 846 times)

michoux

  • Full Member
  • ***
  • Posts: 112
sqlite join
« 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?


madref

  • Hero Member
  • *****
  • Posts: 949
  • ..... A day not Laughed is a day wasted !!
    • Nursing With Humour
Re: sqlite join
« Reply #1 on: July 12, 2020, 10:21:16 am »
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
You treat a disease, you win, you lose.
You treat a person and I guarantee you, you win, no matter the outcome.

Lazarus 3.99 (rev main_3_99-649-ge13451a5ab) FPC 3.3.1 x86_64-darwin-cocoa
Mac OS X Monterey

rvk

  • Hero Member
  • *****
  • Posts: 6162
Re: sqlite join
« Reply #2 on: July 12, 2020, 10:50:26 am »
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

  • Hero Member
  • *****
  • Posts: 2327
Re: sqlite join
« Reply #3 on: July 12, 2020, 02:27:25 pm »
One System to rule them all, One Code to find them,
One IDE to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------
Code is like a joke: If you have to explain it, it's bad

 

TinyPortal © 2005-2018