<p>What does <code>STRAIGHT_JOIN</code> do in this code ?</p>

<pre><code>SELECT  STRAIGHT_JOIN ClosingBalance    
FROM   Accounts 
WHERE idAccounts = FidDebit;
</code></pre>

From
here
:
STRAIGHT_JOIN is similar to JOIN, except that the left table is always read before the right table. This can be used for those (few) cases for which the join optimizer puts the tables in the wrong order.