John,

> I'm a little confused by your suggestion. I build all by complex queries
> with join logic then use the onPrepareSql to provide the various user
> selections made on a form using the sqlwhereitems method. i.e.
> sqlwhereitems.add('X.fieldname = '+form_edit.text). If all this was moved

to

> the join part of the query wouldn't you loose all this great

functionality.

These selections are not used to qualify JOIN criteria is it? Sounds to me
like this is just normal WHERE clause stuff.

No need for alarm...

You see, in this person's case they are doing self joins where there are
literals that get involved in determining one records relationship to
another record in the same table. Because of this they should be kept in the
JOIN clause instead of the WHERE clause.

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