I am trying to combine three queries. All three queries have the same number of fields (7) and the same number of records (391). Four of the fields (BedNB, Sampyear, Treatment, Site) are common to all three queries, and the remaining three fields contain values that are unique to the separate queries.
I would like to create a query that will result in 13 fields (4 common to all and 3 unique to each) and 391 records.
A simple select query (SQL below) results in a huge table with almost infinite records that makes no sense to me.
Any help?
SELECT sqry_DF_Type_Quads.SampYear, sqry_DF_Type_Quads.Treatment, sqry_DF_Type_Quads.Site, sqry_DF_Type_Quads.BedNB, sqry_DF_Type_Quads.Herbaceous AS H_Cover, Count_DF_SpRchnes_Quads.Herbaceous AS H_Rich, sqry_DF_Type_Quads.Vine AS V_Cover,
Count_DF_SpRchnes_Quads.Vine AS V_Rich, sqry_DF_Type_Quads.Woody AS W_Cover, Count_DF_SpRchnes_Quads.Woody AS W_Rich, Fqry_DF_Diversity_Quads.Herbaceous AS H_Diversity, Fqry_DF_Diversity_Quads.Vine AS V_Diversity, Fqry_DF_Diversity_Quads.Woody AS W_Diversity
FROM sqry_DF_Type_Quads, Count_DF_SpRchnes_Quads, Fqry_DF_Diversity_Quads;