Subject Re: [IBO] Links question
Author Svein Erling Tysvaer
Helen simply wants you to use both a join and a where clause, in the
current example:

select t1.pk1, t1.pk2, t1.col1, t1.col2, t2.cola, t2.colb
from atable t1
join btable t2
on t2.fk1 = t1.pk1
and t2.fk2 = t1.pk2
/* so far, so good */
WHERE t2.cola = :myParam
/* and this keeps Helen happy */

Set

At 14:49 26.06.2003 +0200, you wrote:
>select t1.pk1, t1.pk2, t1.col1, t1.col2, t2.cola, t2.colb
> >from atable t1
> >join btable t2
> >on t2.fk1 = t1.pk1
> >and t2.fk2 = t1.pk2
> >/* so far, so good */
> >and t2.cola = :myParam