Use LEFT JOIN on the table where data may or may not be present.