action code:

$c = new Criteria();
$c->addJoin(PermGroupPeer::UPDATEDBY_USER_ID,UserPeer::USER_ID, Criteria::INNER_JOIN);
$this->perm_groups = PermGroupPeer::doSelectOne($c);


resulting SQL:

SELECT perm_group.GROUP_ID, perm_group.NAME, perm_group.NOTE, perm_group.CREATED_AT, perm_group.UPDATED_AT, perm_group.UPDATEDBY_USER_ID
FROM perm_group
INNER JOIN user ON (perm_group.UPDATEDBY_USER_ID=user.USER_ID)
LIMIT 1


template code:

<?php foreach ($perm_groups as $perm_group): ?>
<tr>
    <td><?php echo link_to($perm_group->getGroupId(), 'manage_perm_group/show?group_id='.$perm_group->getGroupId()) ?></td>
      <td><?php echo $perm_group->getName() ?></td>
      <td><?php echo $perm_group->getNote() ?></td>
      <td><?php echo $perm_group->getUser()->getUserLogin() ?></td>
      <td><?php echo $perm_group->getUpdatedbyUserId() ?></td>
      
  </tr>
<?php endforeach; ?>