Hint - Join Types?

Keep all geometry records corresponds to a LEFT OUTER JOIN.
Keep only matching records corresponds to an INNER JOIN.

Visit the OCAD Wiki for more information.