Subject | Re: [firebird-support] Optimizer request |
---|---|
Author | Helen Borrie |
Post date | 2016-09-10T00:46:18Z |
Hello Ann,
Saturday, September 10, 2016, 8:51:05 AM, you wrote:
select o.*
from orders o
inner join partners p
on p.partid = o.opartid
where p.country = 'Spain';
H.
Saturday, September 10, 2016, 8:51:05 AM, you wrote:
> If I were writing this query, I'd writeI'm sure this was a slip of the pen, Ann... you meant
> select o.*
> from orders o
> inner join partners p
> where p.partid = o.opartid
> and p.country = 'Spain';
select o.*
from orders o
inner join partners p
on p.partid = o.opartid
where p.country = 'Spain';
H.