Posted by Tarscher on 12/21/07 08:43

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

• Next in forum: Re: Will the code be much different if requirement on the number of maximum concurrent visitors is greatly different?
• Prev in forum: Re: Get Windows Login from php using IIS
• Thread view: difficult query

[Reply to this message]