Thank you. Next time I will make sure that I do that. I figured out a solution to the problem. I can not use the Join

I ended up with this code to get the totals of people where the SQL actually gave me the total of people in an area not licenses. I do not know why the joins did not work. I still think and INNER JOIN should have been the answer but this returns mulitples of the same value. Even if I use the DISTINCT modifier. Strange.

To get the total of people in an area based on my tables, took a nested Select statement.

SELECT Count(um.UserNumber)

From [dbo].[UserMain] um

WHERE um.UserNumber in (SELECT pro.UserNumber from [dbo].[Professional] pro, [dbo].[UserMain] umm WHERE umm.UserNumber = pro.UserNumber)

and um.User_status = 'C' and um.Base_State = 'MA'