Hi, Can somebody tell me if there is a way to accomplish this update without locking both tables.
UPDATE t1, t2 SET t2.a = t1.a WHERE t2.id = t1.id t1 is not being updated yet it becomes locked and does not allow any read queries until it is done. Can somebody help? Thanks, Mike. ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **********************************************************************