SELECT * FROM office WHERE office_city = '#url.city#' SELECT * FROM office WHERE office_city = 'Washington' SELECT first_name, last_name, indiv_title, indiv_portfolio, indiv_email, isnull(indiv_order,9999) AS indiv_order FROM indiv INNER JOIN link_indiv ON indiv.indiv_id = link_indiv.fk_id WHERE office = #office.office_id# AND link_indiv.code_id = 79 AND indiv.live = 1 ORDER BY indiv_order, last_name

#office.office_description#

#office.office_address1#
#office.office_address2#
#office.office_address3#
#office.office_address4#
#office.office_city#, #office.office_state# #office.office_postal_code#
#office.office_country#
#office.office_city#, #office.office_state#, #office.office_country# #office.office_postal_code#
Map It!
Tel: #office.office_phone#
Fax: #office.office_fax#
Email: #office.office_email#

#office.office_city# Office Staff

#officestaff.first_name# #officestaff.last_name#
#officestaff.indiv_title#
#officestaff.indiv_portfolio#
#lcase(officestaff.indiv_email)#