Solved

Update table value with join syntax

Posted on 2016-09-01
2
77 Views
Last Modified: 2016-09-01
I have two tables that have a common field (to join)

Table 1:  Forms
Field 1: FormName (varchar 40)
Field 2: FormDesc (varchar 255)

Table 2: FormsCatalog
Field1: FormName (varchar 40)
Field 2: FormDesc (varchar 255)

I want to join both tables b the FormName, which is the same in both. And update the table 2 field 2 with the value of table 1 field 2

Something like

Update Formscatalog a
set a. FormDesc = b.FormDesc
where a.Formname JOINED TO b.FormName
and Forms as b

Open in new window


Obviously the syntax is incorrect, this is what I need help with. Simply join the tables by the name and have formscatalog.description be the same as forms.description

Hope I explained myself well.
0
Comment
Question by:amucinobluedot
2 Comments
 
LVL 12

Accepted Solution

by:
funwithdotnet earned 500 total points
ID: 41780864
In T-SQL, I think something like this may be what you want:
Update a
set a.FormDesc = b.FormDesc
FROM Formscatalog a
INNER JOIN Forms b on b.FormName = a.FormName

Open in new window

0
 

Author Closing Comment

by:amucinobluedot
ID: 41780871
Thx!
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

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. …
Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…

821 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