Muliple table joining with conditional statements

[eluser]Unknown[/eluser]
$query = $this->db->select('album.*, image.*')
->from('td_album, td_image')
->join('td_image', 'td_image.album_id =td_ album.id', 'left')
->group_by('album.id');

$query = $this->db->get();
return $query->result();