Query based on Query

  • Thread starter Thread starter Sharon
  • Start date Start date
S

Sharon

I have a query that returns my patent records. I used that query, Query1,
and created a new query using another table, Assignment Information, Query2.
The primary key for both tables is PatentID. The join is all records from
Query1 and those from Assignment Information where the fields are equal. The
problem is that the first query shows the appropriate number of patents, but
the second query shows the same patent 10 times. There don't appear to be
any duplicate fields, so I am not sure why there are so many duplicate
records.
 
It would help if you posted the SQL of your queries.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
Back
Top