I get this error message:
An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.
When I run this query:
FROM dbo.Company INNER JOIN
dbo.Company_Division ON dbo.Company.Company_id = dbo.Company_Division.Company_id
where count(dbo.Company_Division.division_id) > 1
What does this mean? I simply want to return the company names that have more than one division.