?
Solved

update one table from another

Posted on 2013-11-18
4
Medium Priority
?
240 Views
Last Modified: 2013-11-18
Hello, I need a little assistance with a simple update statement.

Update [dmr tracking] Set  [dmr tracking].PartCost  = [trna part number].[Piece Cost]
Where [dmr tracking].[part number] = [trna part number].[Part Number]

What am I doing wrong?
0
Comment
Question by:gogetsome
  • 2
4 Comments
 
LVL 40

Expert Comment

by:lcohan
ID: 39657731
update [dmr tracking]
      set [dmr tracking].PartCost  = [trna part number].[Piece Cost]
from [trna part number]
Where [dmr tracking].[part number] = [trna part number].[Part Number]
0
 

Author Comment

by:gogetsome
ID: 39657740
Hello, I'm getting the following error.

syntax error (missing operator) in query expression '[trna part number].[piece cost] from [trna part number]'.
0
 
LVL 61

Accepted Solution

by:
mbizup earned 2000 total points
ID: 39657743
or this:


Update [dmr tracking], [trna part number] 
Set  [dmr tracking].PartCost  = [trna part number].[Piece Cost]
Where [dmr tracking].[part number] = [trna part number].[Part Number]

Open in new window

0
 

Author Closing Comment

by:gogetsome
ID: 39657748
Thanks man! You rock!
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

839 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