hi, i have a typical one to many relationship between two tables: Table_A: contains, for example, "Stores" (id, store_name) Table_B: contains products, "Prod", and which store the products belong to: (id, name, store_id)
I need to create a query where i get all "Store" objects ordered by the number of products, e.g: store_3 34 (amount of products) store_1 23 (ditto) store_2 18 (ditto) any idea? cheers, sandor -- You received this message because you are subscribed to the Google Groups "sqlalchemy" 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/sqlalchemy?hl=en.
