/**
* @param Select $select
* @return string
*/
protected function _renderJoin(Select $select)
{
$sql = $select->getJoinType() ? "{$select->getJoinType()} " : "";
$sql .= "JOIN";
$sql .= " ";
$on = " ON ";
$sql .= $this->_renderTableWithAlias($select->getTable());
$sql .= $on;
$sql .= $this->_renderFilter($select->getJoinCondition(), 1);
return $sql;
}
