Yes, this solves the problem. This is the one limitation that I impose on
people to have all of the benefits that IBO offers is to:

DON'T PUT JOIN CRITERIA IN THE WHERE CLAUSE, EVER.

Either use the JoinLinks property or use the FROM ... JOIN ... declarative
syntax for JOINs.

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <guido.klapperich@...>
To: <IBObjects@egroups.com>
Sent: Tuesday, January 02, 2001 1:24 PM
Subject: Re: [IBO] IB_Query phenomenom


>
>
> Jason Wharton wrote:
>
> > Use JoinLinks and never put join criteria directly in the WHERE clause.
> >
>
> Is this the solution of the problem ? Because I built this query dynamicly
and
> when finished, I only do Query.SQL.Add(MyQuery). Using JoinLinks, it will
be
> more difficult, but when it solves the problem, I will do so.
>
> Guido.