Subject | Re: [IBO] Links question |
---|---|
Author | Svein Erling Tysvaer |
Post date | 2003-06-26T13:47:17Z |
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:
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