Hi,
Can someone give me some hints as to how to do an update with join or update with select in Progress? Standard SQL update queries that work in MySQL, Oracle etc. that doesn't work and I spent a couple hours combing thru the forums and didn't find anything either.
Basically, I need to update values in table1/field1 with values from table2/field2 with a join or select from table1 and table2 with a common key.
Thanks.
Can someone give me some hints as to how to do an update with join or update with select in Progress? Standard SQL update queries that work in MySQL, Oracle etc. that doesn't work and I spent a couple hours combing thru the forums and didn't find anything either.
Basically, I need to update values in table1/field1 with values from table2/field2 with a join or select from table1 and table2 with a common key.
Thanks.