Combine tables with identical row labels

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have four different tables, each with identical row labels that I am trying to combine. Each of these tables has different columns. What is the most efficient way to merge these tables together such that I will end up with one table with all of the columns from each of the four separate tables?
 
union clause with dummy fields in select statements not containing the unique
field in other tables.

Rich
 
Back
Top