Merging Coulmns in separate tables

  • Thread starter Thread starter kfowlow
  • Start date Start date
K

kfowlow

I have sample data from different labs in two different tables. The results
from the labs have been equalized so that I can merge the data from the two
tables together. Now what I want to do is to make a query to merge the data.
These are separate samples from different labs so there are no keys that are
the same. How do I go about doing this in a query? Also, I am going to be
adding more samples to the tables. How do I append samples to this merged
table.

Thanks
 
Karl,
Thanks for replying. Here is a generic list of data.

Table 1
SampleID Lab# Data
1000 1 1005
1001 1 900
1002 1 850
1003 1 925

Table 2
SampleID Lab# Data
2000 2 500
2001 2 450
2002 2 900
2003 2 840

As you can see the data is fairly straight forward. What I want to do now is
to make one table out of the two tables. Cannot really use append. Create
table is really the only way to go. What I may have to do is to make one
table with Table 1 and then append Table 2 to the end. That would make me
generate two queries.

Any help is appreciated.
Thanks
 
I have sample data from different labs in two different tables. The results
from the labs have been equalized so that I can merge the data from the two
tables together. Now what I want to do is to make a query to merge the data.
These are separate samples from different labs so there are no keys that are
the same. How do I go about doing this in a query? Also, I am going to be
adding more samples to the tables. How do I append samples to this merged
table.

Thanks
Click to expand...

If you have no way to identify which record in one table is for the same
sample as a record in the other table ("no keys") then I cannot imagine any
way to do so. If you had these results printed on two stacks of paper, how
would you pair them up?
 
If you want the data to look like this --
SampleID Lab# Data
1000 1 1005
1001 1 900
1002 1 850
1003 1 925
2000 2 500
2001 2 450
2002 2 900
2003 2 840

then use a union query like this ---
SELECT [SampleID], [Lab#], [Data]
FROM [Table 1]
UNION ALL SELECT [SampleID], [Lab#], [Data]
FROM [Table 2];
 
Back
Top