Tengo un query que genera este resultado:
problem_category_description line_name issue_date problem_total
Form V1.3 Clockspring AB 2014-06-23 9
Function V1.3 Clockspring AB 2014-05-05 4
Function V1.3 Clockspring AB 2014-05-06 7
Function V1.3 Clockspring AB 2014-06-09 5
Function V1.3 Clockspring AB 2014-06-12 2
Function V1.3 Clockspring AB 2014-06-17 1
y quiero llegar a este otro resultado:
problem_category_description line_name 2014-06-23 2014-05-05 .....
Form V1.3 Clockspring AB 9 0
Function V1.3 Clockspring AB 0 4
...
.....
Esta es la sintaxis del query:
Código SQL:
Ver originalSELECT problem_category_description, line_name, issue_date, COUNT(problem_category_id) AS Problem_Total
FROM dbo.Dvd2
WHERE (area_id = '2') AND (line_id = '63')
GROUP BY problem_category_description, line_name, issue_date, failure
Agradeceria su ayuda =)