You can negate a part of a query by using a tilde (~).
On Tuesday, March 5, 2013 10:30:50 AM UTC-7, 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.
