That's exactly what was causing the issue. I had a duplicate in table b. Thanks for the assist!

David

That did the trick, I knew it would be something really obvious too. Thanks!

Took me forever to finally solve the problem. The issue was both that I was using a Union All rather than a join and that I had duplicate records in...

Yes you are right. But I did run the code with both Union and Union all. With Union I had slightly less rows returned, but still basically the same...

I have been scratching my head over this all day... Cause I do not understand the logic behind the way the query is running. I've scaled down the...

I modified the code slightly to add an or statement with an additional criteria and I am now getting closer to the number I want, but I'm still not there....

I needed to add some sort of Catch all statement that will force the query to grab all 106k rows and just fill in the column PBCAT with "Unmapped" if...