I have question related to joining over multiple tables. Probably this is more a sqlalchemy question but I did not manage to convert my snippet from Elixir to SQLAlchemy so I don't want to annoy the nice people on the sqlalchemy list with stuff they don't know...
My example code can be found here: http://pastebin.com/f4ca0b65d The SQL query I like to construct with Elixir/SQLAlchemy is something like: select distinct u.id, u.name, p.name from users u inner join subscriptions s on u.id=s.user_id inner join products p on s.product_id=p.id where u.balance > p.price I tried things like: User.query.join("subscriptions").join("product")... but the second join still references the "User" table. I found a nice posting from the SQLAlchemy list: http://groups.google.com/group/sqlalchemy/browse_thread/thread/2dc38bbe2ba5fa9f So I can join all tables with User.table.join(Subscription.table).join(Product.table) but I did not manage to use filter/get an executable expression... All help appreciated :-)) fs --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SQLElixir" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlelixir?hl=en -~----------~----~----~----~------~----~------~--~---
