[web2py] Write Inline query

[vijay....@agnicient.com]

Hi All,

I really need help with a query?

this is my query:


Select * from Table1 where Column1 not in (Select Column2 from Table2);

How to write Query in Web2py DAL Sql From Grid

[Niphlod]

not_in = db(db.table2.id>0)._select(db.table2.column2)


query = db(~db.table1.column1.belongs(not_in)).select()

[Ruslan Gareev]

Hi. This should be in documentation. I have spent 20 minuts to find this :)

среда, 3 декабря 2014 г., 17:06:05 UTC+5 пользователь Niphlod написал: