Whats happening?

[hrov]

errrm i'm not sure about whats happening with my queries at the minute.

I have entered lets say, a customer with an address. And then another customer with a different address.

I now have customer A with address A. Aswell as customer B with address B.

When i do a query, this is what is returned:
Customer A address A
Customer A address A
Customer B address B
Customer B address B

If i was to enter (into the table being queried) customer C with address C I would get:
Customer A address A
Customer A address A
Customer A address A
Customer B address B
Customer B address B
Customer B address B
Customer C address C
Customer C address C
Customer C address C

WHAT IS HAPPENING?

 

[boblarson]

sounds like you have a table in your query that isn't linked via a join and therefore you are getting a Cartesian product (Number of Records in table1 * number of records in table2).