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.

Reply via email to