On May 12, 8:51 am, Razvan Socol <rso...@gmail.com> wrote:
> Hello, Hulicat
>
> Try something like this:
>
> select count(*) as Total, location_name, problem_type_name
> from job_ticket j
> inner join problem_type p on p.problem_type_id = j.problem_type_id
> inner join location l where l.location_id = j.location_id
> where (report_date between '1/01/2005' and '1/31/2007')
> group by p.problem_type_name, l.location_name
>
> Razvan

On May 12, 8:51 am, Razvan Socol <rso...@gmail.com> wrote:
> Hello, Hulicat
>
> Try something like this:
>
> select count(*) as Total, location_name, problem_type_name
> from job_ticket j
> inner join problem_type p on p.problem_type_id = j.problem_type_id
> inner join location l where l.location_id = j.location_id
> where (report_date between '1/01/2005' and '1/31/2007')
> group by p.problem_type_name, l.location_name
>
> Razvan

"Hulicat" <dennis_A_white@yahoo.com> wrote in message
news:1178984050.070688.116240@e51g2000hsg.googlegroups.com...
>I have the following query that executes:
>
>
> select count(*) as 'Total', location_id,
> problem_type.problem_type_name 'Problem Type'
> from job_ticket inner join problem_type on
> dbo.problem_type.problem_type_id =
> job_ticket.problem_type_id where
> (report_date between '1/01/2005' and '1/31/2007')-- and location_id
> ='6'
> group by problem_type.PROBLEM_TYPE_NAME , location_id
>
> output example:
> total Location_id problem_type
> 50 8 add user
>
>
> Output desired example:
> total Location_id problem_type
> 50 California add user
>
>
> Problem I need to diplay location_id as the "location"
>
> I need to tie location_id to the table "Location" and display the
> field Location_name
>
> I tried the following with no success:
>
>
> declare @client varchar (30)
> declare @type varchar (30)
> set @client=6
> set @type= (SELECT location_name 'Client' FROM location where
> location_id =cast (@client as varchar (20)))
>
> Error:
> Subquery returned more than 1 value. This is not permitted when the
> subquery follows =, !=, <, <= , >, >= or when the subquery is used as
> an expression.
>
>
> I am stuck on this any help would be appreciated.
>
> Thanks,
>