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 -~----------~----~----~----~------~----~------~--~---