Carlo Stonebanks wrote:
> If I do an update using the FROM clause, and that clause has a sub-query
> that refers to the table I am updating, will I be waiting for ever for a
> table to lock to release?
You cannot block yourself with a lock, if that's what you mean.
The locks your session takes out will only block other sessions.
Yours,
Laurenz Albe
