Duplicate in query

#1 (**permalink**) 28-Jul-2006, 08:17 AM

Hello,

I joined two query by autonumber ID's

One query has 4 record and the other has 6 records. However on joining them
I get 24 records this amount is due to duplicates what might be causing this.
All that I want is the related fields from that query.

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10927-duplicate-in-query.html
I tried to groups the records in the query with the hope of only getting the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10927
six records from the primary query with related fields from the secondary
query the the "group by" does not work.

help?

*

#2 (**permalink**) 28-Jul-2006, 08:17 AM

4 * 6 = 24

What you have there is a cartesian product! i.e. all records from one table
joined to all the records in the other table.

Specify some kind of join in your query, are you using the design grid to
produce your query? Drag the Primary Key from one table to the Foriegn Key
in the other table and then run the query.

MH

"Levans digital" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10927
news:B1E31BBD-0CD8-4FA6-AFE3-C0B64393C9D7@microsoft.com...
> Hello,
>
> I joined two query by autonumber ID's
>
> One query has 4 record and the other has 6 records. However on joining
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10927
> them
> I get 24 records this amount is due to duplicates what might be causing
> this.
> All that I want is the related fields from that query.
>
> I tried to groups the records in the query with the hope of only getting
> the
> six records from the primary query with related fields from the secondary
> query the the "group by" does not work.
>
> help?

#3 (**permalink**) 28-Jul-2006, 08:17 AM

There's only one practical way for us to know: Show us the SQL. Open the
query in SQL view and copy and past it here. Information on primary keys and
relationships would be a nice touch too.

However since 4 * 6 = 24, it sure looks like a Cartesian join. Are you sure
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10927
that the two tables are joined? Is there a black line between the two tables
in the QBE grid?
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"Levans digital" wrote:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10927

> Hello,
>
> I joined two query by autonumber ID's
>
> One query has 4 record and the other has 6 records. However on joining them
> I get 24 records this amount is due to duplicates what might be causing this.
> All that I want is the related fields from that query.
>
> I tried to groups the records in the query with the hope of only getting the
> six records from the primary query with related fields from the secondary
> query the the "group by" does not work.
>
> help?