set A.ORG_NAME = @ORG_NAME, B.REF_NAME = @REF_NAME
from table1 A, table2 B
where B.ORG_ID = A.ORG_ID
and A.ORG_ID = @ORG_ID
An unexpected token “FROM” was found following “
how do I do multiple table joins in aquadata
Thomas Conrad over 2 years ago
What database and version are you using?
I am using
Aqua Data Studio 18.5.0-2/DB2
I guess I’m not completely clear on what you want to do? I think the syntax is incorrect for your DB2 update statement. You can find examples here.
I updated one table column from another table column using this command.
UPDATE T3 A
FROM T2 B
Hope that helps,