> -----Original Message-----
> From: John Tomaselli [mailto:jrt@...]
> Sent: Miércoles 3 de Enero de 2001 0:58
>
> Jason,
> 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.
> John

John:
where field = value
where field = :param
where field <someop> anotherfield_in_the_same_table
where field in (inner select)
where field >some (inner select)
are okay.

where table_1.f = table_2.f
is the problem. So, I think you are doing all okay.

C.