Hi Derek and Anthony, that's make the trick!!
Thank you both!! *Pepe Araya* DiseƱador / Designer On Tue, Mar 5, 2013 at 4:18 PM, Derek <sp1d...@gmail.com> wrote: > 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 a topic in the > Google Groups "web2py-users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/web2py/OOFjQug73q0/unsubscribe?hl=en. > To unsubscribe from this group and all its topics, send an email to > web2py+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- --- 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.