QUESTION POSED ON: 13 January 2005
I am using DB2/400 and want to update the 'VALUE' column of TBL1 WITH 'PRICE' of TBL2.
Here's the description of the two tables.
TBL1 TBL2
------------ ------------
ID | VALUE ID | PRICE
------------ -----------
1 | 10 1 | 100
2 | 20 2 | 200
3 | 30 3 | 300
------------- -----------
SQL)
UPDATE TBL1 SET VALUE=B.PRICE
FROM TBL1 A INNER JOIN TBL2 B
ON A.ID=B.ID
When I run the above query, I get the error message:
"Column qualifier or table B undefined"
But this query works very well on MS SQL server.
Please let me know if this is really impossible.
|
