Hi I have 2 tables on Oracle, I wish to update one column in table A with a value from table b, when a substring of a column value in table A is equal to a value in a column on table b
The following query tells me that there are 3 cases where this occurs:
select A.C1, B.uniqseq, B.ur, B.ad from snp B, PO A where B.uniqseq = trim(substr(A.user,2,20))
I now want to update a column in table A with the values returned in the above query. What syntax should I be using?