Query for Parent containing only ONE type of child

On Jan 18, 3:41 pm, Jamie Collins <jamiecoll...@xsmail.com> wrote:
> > I believe he only wanted those companies that just have
> > Broker Associates and no other titles.
>
> Fair enough Add another test:

Oops! Posted to quick:

SELECT C1.CompanyName
FROM Company AS C1
WHERE EXISTS (
SELECT *
FROM Contact AS T1
WHERE C1.CompanyID = T1.CompanyID
AND T1.Title = 'Broker Associate')
AND 1 = (
SELECT COUNT(*)
FROM (
SELECT T1.Title, T1.CompanyID
FROM Contact AS T1
GROUP BY T1.Title, T1.CompanyID
) AS DT1
WHERE C1.CompanyID = DT1.CompanyID
);

Jamie.

--