Combine tables with identical row labels

S

Scott

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?
 
J

Jessestonecedar

union clause with dummy fields in select statements not containing the unique
field in other tables.

Rich
 
Top