Results 1 to 2 of 2

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

  1. #1
    Join Date
    Jan 2015
    Posts
    35
    Thanks
    20
    Qt products
    Qt5
    Platforms
    MacOS X Windows

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

    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.

  2. #2
    Join Date
    Mar 2008
    Location
    Kraków, Poland
    Posts
    1,418
    Thanked 258 Times in 253 Posts
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

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

    Ask Google about sqlite ATTACH

  3. The following user says thank you to Lesiok for this useful post:

    binary001 (4th January 2019)

Similar Threads

  1. multiple in memory sqlite databases with Qt
    By RolandHughes in forum Qt Programming
    Replies: 3
    Last Post: 25th May 2013, 00:46
  2. Possible to extract source tables from SELECT * query ?
    By BillGates in forum Qt Programming
    Replies: 0
    Last Post: 19th October 2011, 17:20
  3. AES-256 encrypted SQLite databases with SQLCipher
    By Lykurg in forum Installation and Deployment
    Replies: 10
    Last Post: 29th July 2011, 04:22
  4. Replies: 4
    Last Post: 13th July 2010, 06:17
  5. Replies: 4
    Last Post: 14th April 2008, 17:33

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Digia, Qt and their respective logos are trademarks of Digia Plc in Finland and/or other countries worldwide.