;|
> | To: [EMAIL PROTECTED]
>|
> | cc:
2','event
description 2'
'surname 4','given names 4','contact details 4','event 3','event
description 3'
'surname 4','given names 4','contact details 4','event 4','event
description 4'
|
| cc:
|
| Subject: R
On Tue, Jan 21, 2003 at 01:38:42PM -0800, Josh L Bernardini wrote:
>
> Bob,
> First of all, thank you. I never would have gotten here on my own. Only I
> am not quite there.
> Using your example, I have managed to list all the events a person is
> attending and not attending. Wondering if you migh
|
| To: [EMAIL PROTECTED]
|
| cc:
You are looking for a list of people rather than a list of events and
the people attending them. So you want to start your select from People,
not from Events. Get a list of all the people, then filter out those
attending event id 2. You don't want to start you select from epeople
because then
On Tue, Jan 21, 2003 at 08:43:29AM -0800, Josh L Bernardini wrote:
>
> I have three tables, people, events and epeople. epeople includes a person
> id and an event id and works as a list of people attending events in the
> database.
>
> The following query returns a list of all the people partici