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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make one final list from four sources 1
Checking if data exists another table and, if yes, extracting a value 0
Extract info from Multiple Tables & combine into 1 1
Combine Duplicates in Query 0
Transpose Data that involves subquery 0
VBA - retrieve data on last create named range from previous inserted named range 0
Combining Tables 3
Customer Sales Data 3

Back
Top