Is there any way to use multiple tables in an update or a delete? Most databases support doing something like:
Update table1 join table2 on table1.index = table2.index set table1.column = value The only way I know around it is to use a subselect in the filter for the update/delete, but this can take some time with complicated queries. Is there any plans to add this functionality at anytime?? Thanks, Bob Envision Information Technologies Associate [EMAIL PROTECTED] v. 608.256.5680 f. 608.256.3780