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.
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.