SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE table1 (
    id     INTEGER PRIMARY KEY,
    field1 TEXT
)
WITHOUT ROWID;
✓
CREATE TABLE table2 (
    id     INTEGER PRIMARY KEY,
    field2 TEXT
)
WITHOUT ROWID;
✓
CREATE TABLE table3 (
    id     INTEGER PRIMARY KEY,
    field3 TEXT
)
WITHOUT ROWID;
✓
INSERT INTO table1 (
                       field1,
                       id
                   )
                   VALUES (
                       'FOO0',
                       0
                   ),
                   (
                       'FOO1',
                       1
                   ),
                   (
                       'FOO2',
                       2
                   ),
                   (
                       'FOO3',
                       3
                   );
✓
INSERT INTO table2 (
                       field2,
                       id
                   )
                   VALUES (
                       'BAR0',
                       0
                   ),
                   (
                       'BAR2',
                       1
                   ),
                   (
                       'BAR3',
                       3
                   );
✓
INSERT INTO table3 (
                       field3,
                       id
                   )
                   VALUES (
                       'PIP0',
                       0
                   ),
                   (
                       'PIP1',
                       1
                   ),
                   (
                       'PIP2',
                       2
                   );
✓
SELECT * FROM table1;


id
field1


0
FOO0

1
FOO1

2
FOO2

3
FOO3


SELECT * FROM table2;


id
field2


0
BAR0

1
BAR2

3
BAR3


SELECT * FROM table3;


id
field3


0
PIP0

1
PIP1

2
PIP2


SELECT *
FROM table1
JOIN (table2, table3) USING (id);


id
field1
field2
id:1
field3


0
FOO0
BAR0
0
PIP0

0
FOO0
BAR0
1
PIP1

0
FOO0
BAR0
2
PIP2

1
FOO1
BAR2
0
PIP0

1
FOO1
BAR2
1
PIP1

1
FOO1
BAR2
2
PIP2

3
FOO3
BAR3
0
PIP0

3
FOO3
BAR3
1
PIP1

3
FOO3
BAR3
2
PIP2


SELECT *
FROM table1
JOIN table2 USING (id)
JOIN table3 USING (id);


id
field1
field2
field3


0
FOO0
BAR0
PIP0

1
FOO1
BAR2
PIP1

id	field1	field2	id:1	field3
0	FOO0	BAR0	0	PIP0
0	FOO0	BAR0	1	PIP1
0	FOO0	BAR0	2	PIP2
1	FOO1	BAR2	0	PIP0
1	FOO1	BAR2	1	PIP1
1	FOO1	BAR2	2	PIP2
3	FOO3	BAR3	0	PIP0
3	FOO3	BAR3	1	PIP1
3	FOO3	BAR3	2	PIP2