Matching a query to a query

  • Thread starter Thread starter Sam Hobbs
  • Start date Start date
S

Sam Hobbs

This should be very simple.

I have two queries and I want to match the two. I want the number of result
records to be the same as the first query. I just want to use the two key
fields to match the first query's records to the other query to get a single
field that is an additional field for the result. Regardlous of what I do,
though, I always get nearly 8 times as many result records as I have in the
first query. In other words, I have tried both join types and both result in
the number of result records to be much greater than I need.

I actually need to match the first query to two other queries, but I have
created a query with just the two queries as described above. I assume that
if I get the query that has just two queries to work, that I will know how
to get the third one also.
 
This should be very simple.

I have two queries and I want to match the two. I want the number of result
records to be the same as the first query. I just want to use the two key
fields to match the first query's records to the other query to get a single
field that is an additional field for the result. Regardlous of what I do,
though, I always get nearly 8 times as many result records as I have in the
first query. In other words, I have tried both join types and both result in
the number of result records to be much greater than I need.

I actually need to match the first query to two other queries, but I have
created a query with just the two queries as described above. I assume that
if I get the query that has just two queries to work, that I will know how
to get the third one also.
Click to expand...

Please post the SQL view of the three queries.

John W. Vinson[MVP]
(no longer chatting for now)
 
John Vinson said:
Please post the SQL view of the three queries.

John W. Vinson[MVP]
(no longer chatting for now)
Click to expand...

Thank you.

I was in the process of creating a simplified version of the problem when I
discovered another source of duplicates. Removing those fixed the problem.
 
Back
Top