Tim, Set,

I was going to reply: Now, that's for YOU to show US (expecting Tim to
have a Moment of Truth).

H.

At 03:47 PM 26/06/2003 +0200, you wrote:

>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
>
>
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
>http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/