If you allow me some more questions, I can now retrieve info from the cards table using:
s = select([card_table.c.id],(card_table.c.key.in_(s_inner)) ) Similarly from the revision table s = select([repetition_table.c.actual_interval_s], (repetition_table.c.rep_number==3) & (repetition_table.c.card_key.in_(s_inner)) ) However, I'd also like to get both information simulaneously, as the ordering in both queries seems different. I tried this: j = card_table.join(repetition_table, repetition_table.c.card_key.in_(s_inner) & (repetition_table.c.rep_number==3)) s = select([card_table.c.id,repetition_table.c.actual_interval_s], from_obj=[j]) But this went Cartesian again... A second minor point: is it possible to get select to return a list of scalars [1,2, ...], rather than a list of tuples [(1,),(2,..), ...] Peter --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---