What does STRAIGHT_JOIN
do in this code ?
SELECT STRAIGHT_JOIN ClosingBalance
FROM Accounts
WHERE idAccounts = FidDebit;
STRAIGHT_JOIN is intended as an instruction to the MySQL query optimiser that the tables must be joined from left to right in the order they are listed in the query.
http://dev.mysql.com/doc/refman/5.0/en/join.html
As you only have one table in this query, it wouldn't appear to be doing anything.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With