[sqlalchemy] Re: joins with limit offset

2008-10-25 Thread ershadul.hoque
thanks a lot for your solution. But i have been caught by the following error. Please help me. bye (OperationalError) (1054, Unknown column 'journals.id' in 'on clause') u'SELECT anon_1.journals_id AS anon_1_journals_id, anon_1.journals_amount AS anon_1_journals_amount,

[sqlalchemy] Re: joins with limit offset

2008-10-23 Thread Michael Bayer
On Oct 23, 2008, at 8:58 AM, ershadul.hoque wrote: 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