$row = $this->fetchRow($this->select()->setIntegrityCheck(false) ->from('rcode')->where('rcode.rcode_id = ?',$rcode_id) ->joinLeftUsing('user', 'rcode_id')->joinLeftUsing('company', 'rcode_id'));