August 25, 2009 at 6:32 am
Good morning all,
I am trying to count "Disposition_Description" then COUNT the Defect_Title by date but total Dispositions
SELECT
tlkp_Defects.Defect_Title,
count(*) AS Defect_Count, tlkp_Disposition.Disposition_ID, Count(tlkp_Disposition.Disposition_Description), tlkp_Disposition.Disposition_Description
FROM
tbl_Assembly_Holds
join tlkp_Disposition on tbl_Assembly_Holds.Disposition_ID = tlkp_Disposition.Disposition_ID
join tbl_Assembly_Hold_Defects on tbl_Assembly_Hold_Defects.TagNumber = tbl_Assembly_Holds.TagNumber
join tlkp_Defects on tbl_Assembly_Hold_Defects.Defect_ID = tlkp_Defects.Defect_ID
WHERE
tbl_Assembly_Holds.Record_Date BETWEEN '8/20/2009' AND '8/24/2009'
GROUP BY
tlkp_Defects.Defect_Title, tlkp_Disposition.Disposition_Description, tlkp_Disposition.Disposition_ID
August 25, 2009 at 8:20 am
I think I found the solution.
Thanks.
SELECT
tlkp_Disposition.Disposition_Description, count(*) AS Disposition_Count, tlkp_Defects.Defect_Title
FROM
tbl_Assembly_Holds
join tlkp_Disposition on tbl_Assembly_Holds.Disposition_ID = tlkp_Disposition.Disposition_ID
join tbl_Assembly_Hold_Defects on tbl_Assembly_Hold_Defects.TagNumber = tbl_Assembly_Holds.TagNumber
join tlkp_Defects on tbl_Assembly_Hold_Defects.Defect_ID = tlkp_Defects.Defect_ID
WHERE
tbl_Assembly_Holds.Record_Date BETWEEN '8/20/2009' AND '8/21/2009'
GROUP BY
tlkp_Defects.Defect_Title, tlkp_Disposition.Disposition_Description
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply