>or
>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 = 'whiskas' <-- the reverse here, a where criterion in the
>join spec

How do you handle the above example then? I have plenty where I have
something like

>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

[Non-text portions of this message have been removed]