select query, join question

[Jakeman]

PHP Code:

// SELECT UPCOMING EVENTS FROM DATABASE
$msc_events = $DB_site->query("SELECT*
    FROM msc_events
    LEFT JOIN calendar_events ON (calendar_events.eventid = msc_events.eventid)
    WHERE (UNIX_TIMESTAMP('$msc_date_extended')) <= UNIX_TIMESTAMP(calendar_events.eventdate)
    AND UNIX_TIMESTAMP(calendar_events.eventdate) <= (UNIX_TIMESTAMP('$msc_month_extended'))
    AND calendar_events.public = 1
    ORDER BY calendar_events.eventdate ASC
    LIMIT 6
    "); 


Can this query be modified to select rows from calendar_events that both do and don't have an entry in msc_events? I think the LEFT JOIN is limiting the selection to events that join with the msc_events table.