Adding City to Featured Agents

Hi.
I am wanting to add the field 'City' to the Featured Agents Template
(modules/mod_featuredagents/tmpl.default.php)

When i added the field it added the City Id not the City name (as the id is stored in the Agents table in City)

I need to change the helper.php file code so it joins the Cities table and extracts the 'City' Field

Is this simple to change the below in the helper.php file?

$db = JFactory::getDbo();
$db->setQuery("Select * from #__osrs_agents where published = '1' $userSql $userSql1 order by $sort_by limit $number_agents");
$items = $db->loadObjectList();
return $items;

Hi Jim,
When you show agent details in the module, you can use this code
$db->setQuery("Select city from #__osrs_cities where id = '$item->city'");
echo $db->loadResult();

it will show city value of agent
Thanks
Dam

Hi Dam,
Thank you but I cant seem to get it to work.
To clarify..... the code you supplied would be pasted into the template modules/mod_featuredagents/tmpl/default.php instead of the below in red ? (when i try i get a blank page with just one single agent photo)

<?php
if($item->phone != ""){
?>
<div class="phone"><em class="fa fa-phone"></em>&nbsp;<?php echo $item->phone;?></div>
<?php
}
?>

unfortunately I cant get this to work ...

It works in other templates but not the featured agent.