I wrote > > 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
