No its not possible using update statement, Can use a view, but two tables must be one to one relationship only which preserves primary key, then it will be a single update statement.
Al Longobardi has given a very good example, that is possible sure.... On Nov 4, 10:27 am, BigJ <[EMAIL PROTECTED]> wrote: > Is it possible to do an update on multiple tables within 1 statement?
