How to update the list of primary key of one Column in one table into another table : I just added a new data in [Driver Table], afterwards, I want to update [Driver Dimension] to get the value of every new data inserted in Driver Table. I'm using SQL server 2012.

**My Code:** 

      "Update [Driver Dimension] SET [DriverID] = [DriverID] From [Driver Table]"

**ERROR MESSAGE:**

       Ambiguous column name 'DriverID'.

Where both Tables have a column which contains their respective primary keys called [DriverID]
