SQL query to update datastore by comparing two tables

Hi ,

How can i use update for two tables in datastore.

I have table1 and table2

I have tried to use the folowing:

<datastore name="table1">
 		 update @this
               set @this.column1 = ds_table2.column1
               from @this
                inner join ds_stagingtable
                 on @this.coumn2=ds_table2.column2;
</datastore>