1
Answer

Union ALL with different number of columnsl

Photo of ManMan

ManMan
1y
458
1

I have an Employee table with these columns :

  • EmployeeId
  • Fullname
  • Phone
  • Department
  • Team
  • Function
  • Manager

and EmployeeHistory containing the history with different columns, but there are some in common :

  • EmployeeId
  • Fullname
  • Email
  • Geolocation
  • Department
  • Team
  • Function
  • Manager

How can I union them?

Answers (1)

Next Recommended Forum