repeated queries displayed

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

Guest

hi community

any help much appreciated in this query...

scenario

had 3 tables created but they are not link to each other
however
at the "Select Query" window, I displayed out all the 3 Tables
and
when i query say, (custID / lastname / firstname) with a critera <"A" under
the "firstname" column for Table A and run the query,
I got repeated result displayed
but
if i displayed, only Table A, my result will display the exact number of
result based on Table A

why when displayed 3 tables altogether (they are not link), i get repeated
rows ?

much appreciated for explaination :)

thanks community for the help :)
 
When you don't link the objects in the query window you get what is called a
cartesan product. For each record in A, you get all the records in B and C,
for each record in B you get all the records in A and C and for each record
in C you get all the records in A and B. The result is that the quert reyrns
each record in each table multiple times. This is actually a feature and not
a bug. A cartesan product is desired in certain scenarios.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Back
Top