[sqlalchemy] Re: [Sqlachemy Core] Help on joining 3 tables

2014-11-10 Thread Tiago Guimarães
done! *connection.execute(sel)* On Friday, November 7, 2014 5:16:36 PM UTC-2, Tiago Guimarães wrote: > > Hi. > > Could anyone help me with "translating" the following SQL to Sqlalchemy > Core? > > SELECT A.id, >B.id, >C.id > FROM A >

[sqlalchemy] [Sqlachemy Core] Help on joining 3 tables

2014-11-07 Thread Tiago Guimarães
Hi. Could anyone help me with "translating" the following SQL to Sqlalchemy Core? SELECT A.id, B.id, C.id FROM A LEFT OUTER JOIN B ON B.some_col = A.some_col LEFT OUTER JOIN C ON C.other_col = A.other_col The problem I'm facing is that the *Select().select_from(fromclause*) meth