> Jason has sometimes told us to either use this explicit join syntax or use
> JoinLinks (maybe this cause you the trouble), and I doubt you need for
> update when you have specified EditSQL.

Yes! The query did indeed have a problem.

Please, the rule of thumb is NEVER put JOIN criteria in the WHERE clause.

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