Skip to main content
Question

Merging two different tables to with some similar columns

  • May 30, 2018
  • 0 replies
  • 37 views
In an application one table is having employee information and i want to add some more columns with data needs to align with existing information.

EX: Existing table has Employee ID, F.name, L.name and in another table has employee ID, title where now I need Employee ID and F.name, L.name & title in on one table.

What would be the best approach for this ?
    This topic has been closed for replies.

    • RobIV
    • Registered
    • May 30, 2018
    If the Employee ID of the Employee in the 'name' table represents the Employee ID of the Employee in the 'title' table, I would simply import the 'title' table into the 'name' table.

    You would have to add the 'title' field to the 'name' table first, but then it should work like a charm.
    Terms & ConditionsAccessibility statement