I have the following database and I need to query for the "trees"
without "fruit":
db.define_table('tree')
db.define_table('fruit', Field('tree', db.tree))
Until now I have simply queried for all the trees, then for all fruit,
and removed these tree IDs.
But now I have ~150K trees so it needs to be more efficient.
Is this possible in a single query?
thanks,
Richard
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
