CREATE TABLE test (col1 INT PRIMARY KEY, col2);
CREATE TABLE test2 (col1, col2 INT REFERENCES test(col1));
INSERT INTO test VALUES (1,111), (2,222);
INSERT INTO test2 VALUES (1,1), (2,2);
SELECT * FROM test WHERE col1 BETWEEN 1 AND 1;
2 Fichier SQL
/* load: data.db */
/* test */
SELECT * FROM test;