MYSQL - What does STRAIGHT_JOIN do in this code?

Question

What does STRAIGHT_JOIN do in this code ?

SELECT  STRAIGHT_JOIN ClosingBalance    
FROM   Accounts 
WHERE idAccounts = FidDebit;

Ilailaire

Answer 1

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.

Talon

Answer 2

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.

Polik