Lynn,

I am sorry. I was working late and went to bed the moment I posted my question. I looked at the query which you posted and after a minor change,...

I understand Lynn. I told you that I was new. Here is what I have

SELECT region.name, count(employee.employee_id) as Num

FROM employee INNER JOIN

region ON employee.regionid = region.regionid INNER JOIN

sale ON...

I am sorry Lynn . Below is all the info you require.

/****** Object: Table [dbo].[sale] Script Date: 04/30/2011 02:01:36 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE...