Search results

Hello, New to progress but understand that cant use a subquery in SQL ref an update statement. What I am trying to do is : UPDATE pub.sales t1 set t1.DESC = (select t2.DESC from pub.product t2 where t2.PRODUCTCODE = t1.PRODUCTCODE ) ie, Look up a value from a related table to update the...