How to get in view username from userid (notes table and client table)

[nemanja]

At the moment I use the code below and when i want to display Username i got number (23 - userid from notes table).

How can I get his Username in view (exmp. Jhon Doe)?

Code:
$idiscCode = '{client___id}';

$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query
->select('note, date_time, userid')
->from('map_notes')
->where('map_id = ' . $db->quote($idiscCode))
->order($db->quoteName('date_time') . ' DESC');

$db->setQuery($query);
$iused = $db->loadObjectList();

foreach ((array)$iused as $row)

{

$list[] = "<li>" . $row->userid . "<br /><br />" . $row->date_time . "<br /><br />" . $row->note . "<br /><br /></li>";
return "" . implode(array_filter($list)) . "";
}

 

[cheesegrits]

$idiscCode = '{client___id}';

$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query
->select('m.note, m.date_time, u.name')
->from('map_notes AS m')
->leftJoin('#__users AS u ON u.id = m.userid
->where('m.map_id = ' . $db->quote($idiscCode))
->order($db->quoteName('date_time') . ' DESC');

$db->setQuery($query);
$iused = $db->loadObjectList();

foreach ((array)$iused as $row)

{
$list[] = "<li>" . $row->username . "<br /><br />" . $row->date_time . "<br /><br />" . $row->note . "<br /><br /></li>";
}
return "" . implode(array_filter($list)) . "";

 

[nemanja]

This code works for me. Thanks