[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

find and replace in sql between two tables??

Posted on 2008-10-23
2
Medium Priority
?
171 Views
Last Modified: 2012-05-05
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.
0
Comment
Question by:dkim18
2 Comments
 
LVL 39

Accepted Solution

by:
BrandonGalderisi earned 2000 total points
ID: 22790213
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
 

Author Closing Comment

by:dkim18
ID: 31509397
Thanks much.
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
How to fix display issue, screen flickering issue when I plug in power cord to the machine. Before I start explaining the solution lets check out once the issue how it looks like after I connect the power cord. most of you also have faced this…

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question