Solved

UPDATE FROM QUERY

Posted on 2008-10-18
1
272 Views
Last Modified: 2012-05-05
I need SQL query language statement help
I need to update a field in one table with the value of a field in another table using a query statement where both tables have a common employerID, employeeID and TrasnactionID
Both fields are varchar(3) values.
0
Comment
Question by:mismcc
1 Comment
 
LVL 60

Accepted Solution

by:
chapmandew earned 250 total points
Comment Utility
update t2
field = t1.field
from table1 t1
join table2 t2 on t1.employeeid = t2.employeeid and t1.transactonid = t2.transactionid
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now