[web2py] Re: SQL query to find all records which are not in another table

Hi, Leonel. Thank you for taking me to the right way. It works well: rows = db(~db.persons.id.belongs(db()._select(db.tbl.person))).select() And I don't use dots in table names. On Monday, November 10, 2014 10:56:17 PM UTC+3, Leonel Câmara wrote: > > You can use belongs. You ask for those th

[web2py] Re: SQL query to find all records which are not in another table

You can use belongs. You ask for those that do not belong. http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#belongs something like tbl_person = db()._select(db['tbl.person'].id) db(~db.persons.id.belongs(tbl_person)).select() Do you actually have dots in your tabl