[web2py] is this query possible or should I do a loop

[Richard Vézina]

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