you're almost there. flip a few lines around to rewrite the query to select from product... e.g. something like
SELECT r_product_list.* FROM r_product_list JOIN r_product_category_history_list on r_product_list.r_id=r_product_category_history_list.r_id JOIN r_product_reviews_historical_details_list on r_product_list.most_recent_historical_reviews_id=r_product_reviews_historical_details_list.id then it should be clear how to convert to the sqlalchemy syntax. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- 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 https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.