This is awesome! Thanks for the example! On Thursday, August 30, 2012 1:56:09 PM UTC-7, Anthony wrote: > > > > db.define_table('person', Field('name'), Field('email')) > db.define_table('dog', Field('name'), Field('owner', 'reference person')) > db.executesql([SQL code returning person.name and dog.name fields], fields > =[db.person.name, db.dog.name]) > db.executesql([SQL code returning all fields from db.person], fields=db. > person) > db.executesql([SQL code returning all fields from both tables], fields=[db > .person, db.dog]) > db.executesql([SQL code returning person.name and all db.dog fields],fields > =[db.person.name, db.dog]) > >
--