The Statement below provides an example of the data I have below which shows about 4000 records. However, my second statment below the first data sample, provides higher count of...

sorry, but I don't see a difference than from what I posted.

you only ommitted the dbo.propdb in front of the table names.

here is my current stmt. I need to count how many TRNCD.DESCRIPT, UMMTR.XSIZE

SELECT DISTINCT

...

I have my tables inner join. Would I use a stmt within a stmt?

What if you need to this but the type is in another table?