title: In Yii2 make db query(include 'join' expression) to oracle, cannot fetch any result
body: <p>Here's the code in controller</p>
  
  <pre><code>public function actionIndex()
  {
  
      $result = new RestResult();
      try {
          $query = TaskMgr::find()
              -&gt;join('INNER JOIN', EqpInfo::tableName(), EqpInfo::tableName() . '.EQP_COD =' . TaskMgr::tableName() . '.EQP_COD')
  
              -&gt;select([TaskMgr::tableName() . '.EQP_COD', TaskMgr::tableName() . '.TASK_STA', TaskMgr::tableName() . '.TASK_DATE', TaskMgr::tableName() . '.BUSINESS_NATURE', EqpInfo::tableName() . '.EQP_SORT_NAME', EqpInfo::tableName() . '.EQP_VART_NAME', EqpInfo::tableName() . '.USE_UNT_NAME', EqpInfo::tableName() . '.USE_UNT_ADDR', EqpInfo::tableName() . '.INST_AREA_NAME', EqpInfo::tableName() . '.MAKE_UNT_NAME']);
          $result-&gt;content = $query-&gt;asArray(true)-&gt;all();
      } catch (Exception $e) {
          $result-&gt;error = $e-&gt;getMessage();
          $result-&gt;content = [];
          $result-&gt;message = ["error" =&gt; Yii::t('rest', "Server error.")];
      } finally {
          return $result;
      }
  }
  </code></pre>
  
  <p>and I got empty array.<a href="https://i.stack.imgur.com/wS5yH.png" rel="nofollow">as pic 1</a>, I thought it might be the problem of QueryBuilder, so I simply excute the sql script in index action:</p>
  
  <pre><code>public function actionIndex()
  {
      $y = Yii::$app-&gt;get('db2')-&gt;createCommand('SELECT * FROM "TB_TASK_MGR" INNER JOIN "V_EQPINFO" ON "V_EQPINFO".EQP_COD ="TB_TASK_MGR".EQP_COD')
          -&gt;queryAll();
      return var_dump($y);
  }
  </code></pre>
  
  <p>and I got a empty array again.
  but when I ran the sql script in Navicat, I got some rows.<a href="https://i.stack.imgur.com/1ZJRx.png" rel="nofollow">as pic 2</a>, that means the sql result is not empty. I thought it might some problems with my DBConnection, so I tried change the action as :</p>
  
  <pre><code>public function actionIndex()
  {
      $y = Yii::$app-&gt;get('db2')-&gt;createCommand('SELECT * FROM "TB_TASK_MGR"')
          -&gt;queryAll();
      return var_dump($y);
  }
  </code></pre>
  
  <p>and I got some rows, that means there's no problem in DBConnection, the only difference is the 'join' expression.</p>
  
  <p>I use xampp to deploy site, php version is 5.6.23. oracle client installed and remote oracle version is 11g. php.ini config oci as</p>
  
  <pre><code>extension=php_pdo_oci.dll
  </code></pre>
  
  <p>Please help me find out why is this, is it because some bugs in php_pdo_oci.dll? and how to excute sql with 'join' in yii2 to oracle.</p>