User Profile

Collapse

Profile Sidebar

Collapse
Sn0wman
Sn0wman
Last Activity: Aug 21 '14, 08:26 PM
Joined: Aug 21 '14
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Sn0wman
    replied to Update queries using more than one table
    in SQL Server
    Thanks very much .....that's sorted it out although you did throw me for 10mins as one of the tables got renamed in your reply ;-).
    See more | Go to post

      Leave a comment:

    • Sn0wman
      started a topic Update queries using more than one table
      in SQL Server

      Update queries using more than one table

      I am an Access 2010 novice who is trying to update one table with information from another i.e. when table 1 col 1 = table 2 col 1, update table 1 col 2 with table 2 col 2, but keep getting syntax errors when using the following code. Can anyone help point out where I am going wrong.

      Code:
      UPDATE TrafficApr11toDate 
SET [Originating Country] = (SELECT OriginatingCountry.[Mapped Originating Country],
FROM OriginatingCountry
      ...
      See more | Go to post
      Last edited by Rabbit; Aug 21 '14, 04:04 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.
      No activity results to display
      Show More
      Working...