Hi! Try this:
rows_res = db(db.tab1_res)._select(db.tab1_res.tab1_id) rows = db(not db.tab1.tab1_id.belong(rows_res)).select() -- Lucas D'Avila http://flavors.me/lucasdavila Em 15/02/2011 15:09, "Richard Vézina" <[email protected]> escreveu: > Hello, > > I would like to write this in web2py : > > SELECT tab1.tab1_id > FROM tab1 > WHERE tab1.tab1_id NOT IN (SELECT tab1_res.tab1_id FROM tab1_res) > > Try this without success : > > db(db.tab1.tab1_id != > (db().select(db.tab1_res.tab1_id))).select(db.tab1.ALL) > > Thanks > > Richard
