Querying data by joining two tables in two databases

Question

i'm trying to get data from two databases(test1.db,test2.db) which having same table schema as

CREATE TABLE LoginDetails (
    Name varchar(30),
    PassWord varchar(30),
    email varchar(30)
);

How can I get data (email) from these two databases at a time.

I tried this

select
    LoginDetails.Name test1.db LoginDetails
    left join test2.db LoginDetails on LoginDetails.Name = LoginDetails.Name;

but not working Please help to find out solution

Thanks in advance

Possible duplicate of [SQLite - How do you join tables from different databases?](https://stackoverflow.com/questions/6824717/sqlite-how-do-you-join-tables-from-different-databases) — Dai, Aug 28 '17 at 07:40
`on LoginDetails.Name = LoginDetails.Name` does this make any logical sense to you? — Tim Biegeleisen, Aug 28 '17 at 07:41
https://stackoverflow.com/users/1863229/tim-biegeleisen I am new to SQL, i tried from stackoverflow — Sanjeev Kumar, Aug 28 '17 at 07:43

score 1 · Accepted Answer · answered Aug 28 '17 at 07:41

1

Are you looking for union all?

select name, password, email
from test1.db.LoginDetails
union all
select name, password, email
from test2.db.LoginDetails;

answered Aug 28 '17 at 07:41

Gordon Linoff

getting error as below: sqlite> select name from test1.db.LoginDetails union all select name from test2.db.LoginDetails; Error: near ".": syntax error sqlite> select name from test1.db.LoginDetails; Error: near ".": syntax error sqlite> – Sanjeev Kumar Aug 28 '17 at 07:48
@SanjeevKumar . . . Perhaps you need wildcards . . . `test1.db`.LoginDetails. Or perhaps the "db" is unnecessary. – Gordon Linoff Aug 28 '17 at 08:14

1 Answers1