Thanks. =)
On Feb 2, 12:33 am, Johann Spies <[email protected]> wrote: > On 2 February 2012 07:40, shartha <[email protected]> wrote: > > > > > > > > > > > I have two databases as follows: > > > db.define_table('city', > > Field('name'), > > Field('state'), > > format = '%(name)s' > > ) > > > db.define_table('users', > > Field('name'), > > Field('city',db.city), > > Field('phone'), > > Field('email') > > ) > > > What query will list all the users that are from a particular city, > > e.g. with id = 1? > > Say 'Cape Town' is in 'city' then the following query would provide all the > users linked to that city: > > list_of_users_in_cape_town = db((db.city.name == 'Cape > Town')&(db.users.city == db.city.id)).select() > > Regards > Johnann > > -- > Because experiencing your loyal love is better than life itself, > my lips will praise you. (Psalm 63:3)
