Try this for the outer query: >s = select([repetition_table.c.grade],(repetition_table.c.rep_number==2) & (repetition_table.c.card_key.in_(s_inner)) )
Barry ----- Original Message ---- From: pbienst <[EMAIL PROTECTED]> To: sqlalchemy <[email protected]> Sent: Saturday, October 20, 2007 6:55:56 AM Subject: [sqlalchemy] Re: Advice on complicated (?) SQL query Thanks! Based on your suggestion, I tried the following: The inner query goes like this: >repetition_table_2 = repetition_table.alias() >s_inner = select([repetition_table_2.c.card_key], (repetition_table_2.c.rep_number==5) & \ (repetition_table_2.c.grade==2)).limit(10) >print db_session.execute(s_inner).fetchall() [(3,), (8,), (16,), (34,), (27,), (42,), (33,), (32,), (37,), (36,)] Now for the outer query: >s = select([repetition_table.c.grade],(repetition_table.c.rep_number==2) & (repetition_table.c.card_key==s_inner) ) >print db_session.execute(s).fetchall() [(0,)] I seem to be missing 9 entries... I also tried the following trivial outer query, which I suppose should give me back the results of my inner query: >s = select([repetition_table.c.card_key],(repetition_table.c.card_key==s_inner) ) >print db_session.execute(s).fetchall() [(3,), (3,), (3,), (3,), (3,), (3,), (3,), (3,)] Obviously, I'm still missing something... Peter __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
