Query across two SQLite databases in Delphi TFDQuery

Asked Aug 25 '21 at 06:53

Active Aug 25 '21 at 23:27

Viewed 55 times

Is there a way to do an inner join across 2 database SQLite files, when they both uses different sqlite passwords?

Example:

SELECT * FROM table1
INNER JOIN table2 ON table1.some_id = table2.some_id 
WHERE table1.some_id = 5

where table1 is from 1st database file and table2 is in the 2nd sqlite database file.

edited Aug 25 '21 at 23:27

asked Aug 25 '21 at 06:53

Peter Jones

Yes. You can attach another external SQLite database to your primary SQLite database. Then you can query across the two. https://www.sqlitetutorial.net/sqlite-attach-database/ – Kim Madsen Aug 25 '21 at 07:46
sorry, I meant to be more specific. is there a Delphi way of doing it? – Peter Jones Aug 25 '21 at 23:27
There is no "Delphi way". It's just SQL. – Olivier Aug 26 '21 at 07:19

0 Answers0