ManMan

ManMan

  • 1.5k
  • 228
  • 1.3k

Union ALL with different number of columnsl

Feb 27 2024 7:45 PM

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)