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.


Reply via email to