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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
