SELECT WCD.debt_id, Comp.Name, WCD.client_id, WCD.client_name, WCD.AdminID, FA.FirstName + ' ' + FA.LastName AS AdminName, CONVERT(NVARCHAR(10), WCD.CreateDate, 103) AS CreateDate, COUNT(WCS.status_id) AS countStatus 
FROM WCD 
LEFT OUTER JOIN Comp ON WCD.CompanyID = Comp.CompanyID 
LEFT OUTER JOIN FA ON WCD.AdminID = FA.AdminId 
LEFT OUTER JOIN WCS ON WCD.debt_id = WCS.debt_id 
GROUP BY 
WCD.debt_id, Comp.Name, FA.FirstName + ' ' + FA.LastName, WCD.client_id, WCD.client_name, WCD.AdminID, WCD.CreateDate, WCS.status_id 
ORDER BY WCD.CreateDate DESC

GROUP BY 
WCD.debt_id

quote:

---

From BOL
The GROUP BY keywords are followed by a list of columns, known as the grouping columns. The GROUP BY clause restricts the rows of the result set; there is only one row for each distinct value in the grouping column or columns. Each result set row contains summary data related to the specific value in its grouping columns.

There are restrictions on the items that can be specified in the select list when a SELECT statement contains a GROUP BY. Items allowed in the select list are:

The grouping columns.


Expressions that return only one value for each value in the grouping columns, such as aggregate functions that have a column name as one of their parameters. These are known as vector aggregates.

---