|
|
Posted by Captain Paralytic on 12/21/07 14:22
On 21 Dec, 13:56, Tarscher <tarsc...@gmail.com> wrote:
> On 21 dec, 14:02, Captain Paralytic <paul_laut...@yahoo.com> wrote:
>
So here is my guess.
Assuming that you have a table events and a table people, I would have
a link table events_people. I would not call it attendee as it ontains
both attendees and non-attendees.
The query would be something like:
SELECT
e.event,
ep.status
FROM events e
LEFT JOIN events_people ep USING(event_id)
WHERE ep.person_id = {my_person_id}
Navigation:
[Reply to this message]
|