Latest news
Home » Tag Archives: select query cannot join

Tag Archives: select query cannot join

select query cannot join with another table zend framework

$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)  

Read More »