[sqlalchemy] Join query syntax

I have some sqlite tables such as: CREATE TABLE table_a ( id INTEGER NOT NULL, table_b_id INTEGER NOT NULL, name VARCHAR, PRIMARY KEY (id), FOREIGN KEY(table_b_id) REFERENCES table_b (id) ON DELETE CASCADE ); CREATE TABLE table_b ( id INTEGER NOT NULL, table_c_id INTEGER NOT NULL, name VARCHAR,

Re: [sqlalchemy] Join query syntax

On Nov 24, 2013, at 3:34 PM, Joseph Casale jcas...@gmail.com wrote: I have some sqlite tables such as: CREATE TABLE table_a ( id INTEGER NOT NULL, table_b_id INTEGER NOT NULL, name VARCHAR, PRIMARY KEY (id), FOREIGN KEY(table_b_id) REFERENCES table_b (id)