join() join( $joinSpec, array $one, array $two) $rows->join('SomeTable.userId=id AND SomeTable.groupId=?', array(12), array('createdDate' => 'joinedDate')) Parameters $joinSpec array $one array $two