find and replace in sql between two tables??

Hi,
Can you help me write up a sql to find and replace?
table1(id,trigraph)
table2(cid,digraph,trigraph)

I want to replace trigraph of table1 with the digraph.
dkim18Asked:
Who is Participating?
 
BrandonGalderisiCommented:
assuming your link between the two tables is trigraph..

update t1
set trigraph = t2.digraph
from table1 t1
join table2 t2
on t1.trigraph = t2.trigraph
0
 
dkim18Author Commented:
Thanks much.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.