Tarscher schreef:
> Hi all,
>
> I have a users table and every user has many registrations - Also a
> registration has 1 event.
>
> I want to get all the users of which I have the id and their
> registration for an event. I also want to have the user when she
> doesn't has registered for that event.
>
> I have a hard time solving this query.
>
> regards,
> Stijn

start reading here: http://dev.mysql.com/doc/refman/5.0/en/join.html

if you have any further questions, please post the definitions of you
table(s), and what you tried so far....

--
Luuk