hard to tell from the limited description, but you may need to use an OUTER JOIN instead of an INNER in your query. INNER by definition is "lossy", so any records without a corresponding key value in the other table will be eliminated from the final result.