Check out .belongs() -- http://web2py.com/books/default/chapter/29/06#belongs.
Anthony On Tuesday, March 5, 2013 12:30:50 PM UTC-5, Pepe Araya wrote: > > Hi! > > In words what i need is to get a set from this query: select the > 'persons.email' and 'persons.id' from table 'persons' *that are not in*table ' > invitations.to' > > my tables: > > db.define_table('persons', > Field('name'), > Field('email')) > > db.define_table('invitations', > Field('from',db.persons), > Field('to',db.persons)) > > > Any help is welcome. > > Thank you very much. > > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.