Egads you're right! I've been overthinking this. There must something
else wrong in my query.
Thanks for the hit over the head. I needed it.
On Mar 16, 2004, at 10:37 AM, Harald Fuchs wrote:
When you specify a left join, you will always get the same number of
records as are in your primary joi
The DISTINCT key word works on the whole record, not the field that
follows it. So the query actually does return multiple records with the
same EventID when there are multiple related contacts/regardings.
DISTINCT filters out duplicate records created from the joining of the
three tables.
Whe
Original Message -
From: Brent Baisley
To: MYSQL list
Sent: Monday, March 15, 2004 3:32 PM
Subject: Help with a tough query
I didn't think this was too hard when I first created it, but now that
I'm loading test data it's not working as expected.
The core
, 2004, at 4:47 PM, Rhino wrote:
Remarks interspersed below.
Rhino
- Original Message -
From: "Brent Baisley" <[EMAIL PROTECTED]>
To: "MYSQL list" <[EMAIL PROTECTED]>
Sent: Monday, March 15, 2004 4:32 PM
Subject: Help with a tough query
I didn't thi
Remarks interspersed below.
Rhino
- Original Message -
From: "Brent Baisley" <[EMAIL PROTECTED]>
To: "MYSQL list" <[EMAIL PROTECTED]>
Sent: Monday, March 15, 2004 4:32 PM
Subject: Help with a tough query
> I didn't think this was too hard whe
I didn't think this was too hard when I first created it, but now that
I'm loading test data it's not working as expected.
The core of the query is three tables: Event, Contact, and Regarding.
There can be zero or more Contacts for each event and zero or more
"Regardings" for each event. There