Hi The following fails to work in 0.8b2 (Works fine in 0.7.9)
pp = aliased(PublicationPrice, name="pp") ppp= aliased(PublicationPrices, name="ppp") session.query(pp, ppp).\ join(ppp, ppp.id == pp.publicationpricesid).\ filter(pp.publicationid == publicationid).all() It generates the following SQL SELECT pp.id AS pp_id, pp.shopid AS pp_shopid, pp.publicationid AS pp_publicationid, pp.publicationpricesid AS pp_publicationpricesid, pp.dayid AS pp_dayid, pp.activedate AS pp_activedate, ppp.id AS ppp_id, ppp.shopid AS ppp_shopid, ppp.publicationid AS ppp_publicationid, ppp.barcodeid AS ppp_barcodeid, ppp.price AS ppp_price, ppp.onshelf AS ppp_onshelf, ppp.offshelf AS ppp_offshelf, ppp.ean_issue AS ppp_ean_issue, ppp.cover_issue AS ppp_cover_issue, ppp.dayid AS ppp_dayid, ppp.active AS ppp_active, ppp.startdate AS ppp_startdate, ppp.stopdate AS ppp_stopdate, ppp.cover_issue_next AS ppp_cover_issue_next, ppp.org_id AS ppp_org_id, ppp.vat AS ppp_vat, ppp.barcodeidfull AS ppp_barcodeidfull, ppp.activedate AS ppp_activedate, ppp.cost AS ppp_cost FROM publicationprice AS pp INNER JOIN publicationprices AS ppp ON publicationprices.id = pp.publicationpricesid WHERE pp.publicationid = %s The "publicationprices.id" in the ON Clause of the inner join is incorrect it should be "ppp.id" Chris -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy?hl=en. For more options, visit https://groups.google.com/groups/opt_out.