|
Posted by Vince Morgan on 12/21/07 09:29
"Tarscher" <tarscher@gmail.com> wrote in message
news:b9b89855-c327-46ab-9868-78e71993b63f@i29g2000prf.googlegroups.com...
> Hi all,
>
> I have events containing attendees (events has many attendees). The
> attendee table tells whether a user will attend the event or not. I
> want to build a query that returns all the different events to a user
> and if he will attend the event or not (or hasn't filled it in yet)
>
> the returned result could be something like:
>
> event.id attendees.user_id attendee.present
> 1 1 0
> 2 1
> 3 1 1
>
> Please note that attendee.present can be null if the user didn't yet
> tell if he would come to the event.
>
> Can this be done?
>
> thanks
> Stijn
SELECT * FROM Tablename WHERE user_id = 'TargetId'
The above will return all fields for a user id.
SELECT present FROM Tablename WHERE user_id = 'TargetId'
The above will return all "present" for a user id.
However, I imagine there is another table that contains the names of the
persons?
HTH
Vince
Navigation:
[Reply to this message]
|