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 master (t1).
I only have SQL at my disposal to do this (cant use 4GL) so can anyone advise is theri a way to accomodate this in SQL ?
thanks
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 master (t1).
I only have SQL at my disposal to do this (cant use 4GL) so can anyone advise is theri a way to accomodate this in SQL ?
thanks