$select = $table->select()
->setIntegrityCheck(false)
->from($tableName)
->joinRight($subtableName, ‘`’.$subtableName.’`.`user_id` = `’.$tableName.’`.`user_id`’,array(‘resource_approved’,’user_approved’))
->where(‘`’.$subtableName.’`.`resource_id` = ?’, $resource->getIdentity());
Give the following sql statement for avoid “select query cannot join with another table zend framework” mysql error.
setIntegrityCheck(false)