My goal to do select * from table_name where id IN (1,2,3,4,5,6)
The sample shows what I need to do. Sure code is invalid. (1,2,3,4,5,6) - is a list from first DB. For now I am building in a loop huge where clause (id =1 ) OR (id=2) OR .... OR (id=100500) среда, 4 июля 2012 г., 17:38:28 UTC+7 пользователь Marin Pranjić написал: > > 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 <mkostri...@gmail.com> 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 >> > >
