: August 11, 2003 2:21 PM
To: Aaron Wolski
Cc: [EMAIL PROTECTED]
Subject: Re: Help debugging this Query?
Aaron,
It sounds like the join has duplicates on both sides. If you join a-b
where a is unique (like a primary key) then you will get count(b)
records (where b is the rows that match
Aaron,
It sounds like the join has duplicates on both sides. If you join a-b
where a is unique (like a primary key) then you will get count(b)
records (where b is the rows that match a). Or if b is unique then you
will get count(a) records. However if neither a or b is unique you get
count(a) *