title: Medoo InnerJoin query doesn't work on MSSQL database
body: <p>I am using MSSQL as my database and Medoo isn't successfully performing select queries with an INNER JOIN.</p>
  
  <p>This is my query.</p>
  
  <pre class="lang-php prettyprint-override"><code>$configurations = $this-&gt;database-&gt;select("application_configurations", [
    "[&gt;&lt;]environments" =&gt; ["active_environment_id", "id"]
    ], [
      "environments.name"
    ], ["application_configurations.application_id" =&gt; $id]);
  
  </code></pre>
  
  <p>After looking at the query logs, this is what I found was being outputted:</p>
  
  <pre><code>'SELECT [environments].[name] FROM [application_configurations] INNER JOIN [environments] USING ([active_environment_id], [id]) WHERE [application_configurations].[application_id] = 1'
  </code></pre>
  
  <p>MSSQL doesn't like this : </p>
  
  <p>"<code>"active_environment_id" is not a recognized table hints option.</code>"</p>
  
  <p>I would have written this :</p>
  
  <pre class="lang-sql prettyprint-override"><code>select environments.name from application_configurations
  inner join environments on environments.id = application_configurations.active_environment_id
  where application_configurations.application_id = 1
  </code></pre>
  
  <p>Very simple queries work</p>
  
  <pre class="lang-php prettyprint-override"><code>$configurations = $this-&gt;database-&gt;select("application_configurations",
    ["active_environment_id"],
    ["application_id" =&gt; $id]
  );
  </code></pre>
  
  <p>How can I get this to work with MSSQL?</p>
  
  <p>EDIT</p>
  
  <p>I tried using the left join query as suggested in the comments.</p>
  
  <p>It still did not work, this was the query done behind the scenes.</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT [environments].[name] FROM [application_configurations]
   LEFT JOIN [environments] USING ([active_environment_id], [id])
   WHERE [application_configurations].[application_id] = 1`
  </code></pre>