Hi all,
I need to compose a query that searchs for a "string" and updates one of the columns within the string.
Example:
TABLE: A
COL1, COL2, COL3, COL4, COL5
TABLE: B
COL1, COL2, COL3, COL4, COL5, COL55
In plain english I need to
UPDATE TABLE A and
SET A.COL5 = B.COL55
FROM A,B...