RE: SQL Help with update of tables in two different libraries

Elvis, THANK YOU! That worked beautifully.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Elvis Budimlic
Sent: Tuesday, January 16, 2007 1:18 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: SQL Help with update of tables in two different libraries

John, see page 9 (last page), article "Anatomy of a joined update" at this
link:

http://www.centerfieldtechnology.com/publications/archive/December%202006.pd
f

Elvis

Celebrating 10-Years of SQL Performance Excellence

-----Original Message-----
 
I have the following update statement:

UPDATE library1.table 

SET library1.table.field = library2.table.field

WHERE library1.table.number = library2.table.number;

The problem is the following error: [SQL5001]

Column qualifier or table &2 undefined.

It seems to be linked to the Where clause spanning two different libraries.
Does the query have to be handled differently?  Any other ideas?

John A Candidi