Re: [sqlalchemy] Doube join

2010-08-29 Thread Michael Bayer
On Aug 28, 2010, at 1:58 PM, AdriĆ  Mercader wrote: Hi everybody, I'm using SQLAlchemy for the first time, and everything worked as a charm until I got stuck with a double join. That's the expression I'm trying to perform to get a list of the linked articles from a given article, (knowing

[sqlalchemy] Doube join

2010-08-28 Thread AdriĆ  Mercader
Hi everybody, I'm using SQLAlchemy for the first time, and everything worked as a charm until I got stuck with a double join. That's the expression I'm trying to perform to get a list of the linked articles from a given article, (knowing its title): SELECT a2.id,a2.title FROM articles a1 JOIN