select query, join question

[Jakeman]

Maybe some pictures of my tables would help illustrate the situation. Sometimes I confuse problems like this.

I added the msc_events table for my event signup system. An entry is put into the msc_events table when an event is "signupable." If the event creator doesn't want users to be able to signup for the event, then no entry for it is made in the msc_events table.

The calendar_events table is a vBulletin table. I haven't hacked that table at all.

I want to select all public events, linking the two tables by eventid even if the public event in the calendar_events table doesn't have a matching entry in the msc_events table (it isn't "signupable").

The problem I am having right now is that there appears to be no value for eventid when the selected event doesn't have a matching msc_events entry.