hello, I have something like the following tables:

db.define_table('flavor',
    db.Field('name'),
)

db.define_table('ice_cream',
    db.Field('f1', db.flavor),
    db.Field('f2', db.flavor),
)

I am trying to form a query that will return all the ice creams with
the name of each flavour. Note that sometimes the ice cream will have
just 1 flavor so f2 will not be set.
How would I do this 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
-~----------~----~----~----~------~----~------~--~---

Reply via email to