Post ID #13627, No Replies Be the first!
7/23/2009 3:57:01 PM
mebfbi
Fuller Brothers
Tumwater, WA, USA
I am currently working on converting historical data in a Basis BBj environment. With I am doing what would seem to be fairly straight forward UPDATE STATEMENTS - trying to updated tbl a with data from tbl b - Anyway I have tried this a few different ways without success. I have been told that the Basis BBj environment that I am woking in is only SQL 92 Compliant and that is the reason I continue to get Syntax Errors -- so, without further ado here is what I have tried / with the results ----
UPDATE ARHI_1
SET DESCRIPTION = B.DESCRIPTION
FROM INVE B
WHERE ITEM_NO_JOB_ID = B.ITEM_ID
RETURNED . . . . .
UNABLE TO EXECUTE SQL STATEMENT: Syntax error in SQL statement at 'UPDATE
ARHI_1
SET DESCRIPTION = B.DESCRIPTION
<<<<FROM>>>> INVE B
WHERE ITEM_NO_JOB_ID = B.ITEM_ID'.