update multiple tables using joins

I am trying to update table1 based on common data between table1 and table2. But I am receiving the error:

update
table1 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 "
SET

how do I do multiple table joins in aquadata
Parents Reply Children
No Data