PDA

View Full Version : How to Query (join) two tables from two different sqlite databases?



binary001
4th January 2019, 14:30
Hello!

I want to query data from two tables.

eg.
SELECT M.ID, M.Name, M.Year, M.Type, P.MoviePicture FROM Movie as M LEFT JOIN Movie_Image as P ON M.NO=P.NO
Above statement is ok when two tables exist with single database.

My Problem is table named Move is within myMove.db.
Other table named Movie_Image is within myPicture.db.

How to Query (join) two tables from two different sqlite databases?

Thanks.

Lesiok
4th January 2019, 15:42
Ask Google about sqlite ATTACH