Recent

Author Topic: sqlite join  (Read 279 times)

michoux

  • New Member
  • *
  • Posts: 31
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: 823
  • ..... 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 2.0.6 / FPC 3.0.4
Lazarus Trunc / FPC Trunc
Mac OS X Mojave

rvk

  • Hero Member
  • *****
  • Posts: 4281
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

  • Sr. Member
  • ****
  • Posts: 392
Re: sqlite join
« Reply #3 on: July 12, 2020, 02:27:25 pm »
One System to rule them all, One IDE to find them,
One Code to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------
People call me crazy, because i'm jumping out of perfectly fine aircrafts

 

TinyPortal © 2005-2018