Uh...I think foreign keys are supported:
CREATE TABLE main
( id INTEGER,
data TEXT );
CREATE TABLE secondary
( mainid INTEGER REFERENCES main(id),
data TEXT );
That will make your joins:
SELECT * FROM main,secondary WHERE id = mainid;
much more efficient.
-Robby
What's the best way to build a relation between two tables ?
I know that Foreign key is no longer supported.