Home / Questions / 264132
Accepted
Andres
Asked: 2020-05-17 05:06:22 +0800 CST 2020-05-17 05:06:22 +0800 CST

How to join two tables in sqlite

  • 772

Suppose I have two tables with the same column names and the only difference is that one is the continuation of the other, how do I join the two tables (one after the other) to obtain all the data in one? query?

sqlite

1 Answers

  1. Best Answer

    If your tables have the same fields you can use a

    UNION

    something like that

    SELECT v1 FROM t1
 UNION
SELECT v2 FROM t2;

    Here is a link with more information about it.

    SQLITE UNION

    • 1