[web2py] WHERE equivalent in query?

[shartha]

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?

Any help would be appreciated.

Sh.