yes, well, that's nice, but without the information about how the tables are related, the best i can guess at is the following:
which i am almost certain is not going to be what you want
Ok, OK, I'm alittle stir crazy today it's friday and Ive been working on asp.net for 6 day a week since december. Then They but the in the hat and say we need the by monday. Sorry. I dont know what I'm thinking about. Please check the attachment.
SELECT DISTINCT dbo.tblRegionType.region_type AS Region, COUNT(*) AS [Count]
FROM dbo.tblMonitoringPrograms INNER JOIN
dbo.tblRegions ON dbo.tblMonitoringPrograms.New_Plan_ID = dbo.tblRegions.plan_id INNER JOIN
dbo.tblRegionType ON dbo.tblRegions.region_id = dbo.tblRegionType.region_id
GROUP BY dbo.tblRegionType.region_type
Sorry, I ment Coder database. That a database with no referencial intergritty. No data-definitions. etc... I run across it alot with the students right out of School and from the late 90's. They just did'nt teach this stuff back in the day. I mean, A database is still a electronic filling cabanet right. I go to a cabanet and open a file. I dont wont to go to the third peace of paper in the file and look in another cabanet because of a reference.