journals table has id column ledgers table has journal_id column consider that: journals table is mapped in Class Journal(object): pass and similarly ledgers as : Class Ledger(object): pass
Now i want to run this query ( it runs successfully in mysql): select * from (select * from journals limit 2,6) as some_journal inner join ledgers on some_journal.id = ledgers.journal_id please help me. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---