On 3-6-2012 0:27, Dmitry Kuzmenko wrote:

> Hello, Alec!
>
> AS> 2. Changed the query to "A INNER JOIN B ORDER BY X PLAN P", where P is the
> AS> plan generated by FB in #1. Received "Unexpected token PLAN" error.
> AS> 3. Change the query to "A INNER JOIN B PLAN P ORDER BY X" - success!
>
> AS> Why does #3 succeed but #2 fail?
>
> because inner join is not equal to left join.
>

That would not generate a token unknown PLAN error message.

Mark

--
Mark Rotteveel