PRAGMA DisableSimpleColumns; USE plato; SELECT * FROM Input2 AS A JOIN Input4 AS B ON (A.key == B.key) AND (A.subkey == B.subkey) AND (A.value == B.value) ;