https://communities.sas.com/t5/SAS-Data-Management/Update-Transformation-correlated-query/m-p/251106#M6749 Why don't you use the Table Loader transformation? Fri, 19 Feb 2016 13:13:56 GMT LinusH 2016-02-19T13:13:56Z https://communities.sas.com/t5/SAS-Data-Management/Update-Transformation-correlated-query/m-p/250412#M6748 <P>I am facing problem while updating one table from another using key say (product_id). Actually UPDATE transformation has where clause but it is throwing error : something like correlated query .</P><P>Could someone help me how to use correlated query in update transform in SAS DI</P><P>Problem is like this</P><P>Twol table product(prod_id , current_flag) and prod_update(prod_id , current_flag)</P><P>update product a inner join prod_update b</P><P>&nbsp;on (a.prod_id=b.prod_id)</P><P>set a.current_flag=b.current_flag</P><P>&nbsp;</P><P>I want to Achive DI UPDATE transform .Could someone please help me?</P> Tue, 16 Feb 2016 18:22:30 GMT https://communities.sas.com/t5/SAS-Data-Management/Update-Transformation-correlated-query/m-p/250412#M6748 Ashisk 2016-02-16T18:22:30Z https://communities.sas.com/t5/SAS-Data-Management/Update-Transformation-correlated-query/m-p/251106#M6749 Why don't you use the Table Loader transformation? Fri, 19 Feb 2016 13:13:56 GMT https://communities.sas.com/t5/SAS-Data-Management/Update-Transformation-correlated-query/m-p/251106#M6749 LinusH 2016-02-19T13:13:56Z https://communities.sas.com/t5/SAS-Data-Management/Update-Transformation-correlated-query/m-p/251163#M6750 <P>Since DI Studio is involved, I moved this post to the Data Management forum.</P> Fri, 19 Feb 2016 15:37:05 GMT https://communities.sas.com/t5/SAS-Data-Management/Update-Transformation-correlated-query/m-p/251163#M6750 LinusH 2016-02-19T15:37:05Z