You cannot join tables that are not in the same database. You can do:
list_of_ids = db1(...).select(db1.tablename.id).as_list() db2(db2.tablename.id.belongs(list_of_ids)).select() Marin On Wed, Jul 4, 2012 at 12:28 PM, KMax <[email protected]> wrote: > Hello, > Is any way to query subj with DAL sintax? > I am using two databases, and I want select from second one few rows > according to result of select from first database. > > I think this will not work. > db1(db1.tablename.id==db2.tablename.id).select() > > Thanks in advance > -- > Maxim >
