Subject Re: [firebird-support] Optimizer request
Author Helen Borrie
Hello Ann,

Saturday, September 10, 2016, 8:51:05 AM, you wrote:
> If I were writing this query, I'd write


> select o.* 
>      from orders o
>             inner join partners p 
>      where p.partid = o.opartid
>             and p.country = 'Spain';

I'm sure this was a slip of the pen, Ann... you meant

select o.* 
     from orders o
            inner join partners p 
     on p.partid = o.opartid
      where p.country = 'Spain';

H.