Repeated results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created the following database which is made up of a few many to many
relationships. Hence I have created junction tables to connect the tables. My
current problem is that when I input a query, it returns thousands of
results. (the same result duplicated many times. Why is this?

There are only 220 entries that I am searching under and it is returning
10400 results?!

Please help me!
Many thanks.
Felix
 
It sounds like your query is based on more than one table and at least one
of your tables is not joined to at least one other table. All the tables in
your query must be joined to at least one other table.
 
Hi felix,

You have just ask a Million dollar question.
You are creating something that Database folks called "Cartisan Product" (I
think I spell that correct). The cause is that 1 record in 1 table can match
multiple records in another table.

I don not know what you are trying to accomplish. Depends on what you need
to do, there are way to do what you do it.
 
Back
Top