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

Helen suggests the more correct:

 

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

which is more correct. But the firebird optimizer is smart enough to find join

terms, even when misplaced, so the two generate the same plans.  Again, 

with more complex queries, results may differ.

Cheers,

Ann