SSCrazy is correct. I was able to get around this, at least temporarily by using "distinct" after the select. This might not always work.