Posted by daoud97@yahoo.com on 06/02/06 11:49

markc...@hotmail.com schreef:

> Is this what you want?
>
>
> SELECT Mat,
> Dur
> FROM MAND
> GROUP BY Mat,Dur
> HAVING COUNT(*)=2

No.

When i group by 'Mat' i need to filter by 'Mat' having only 'd' in
'Dur'. I d'ont want Mat with 'i' in Dur.

• Next in forum: Re: Interface for SQL Server database
• Prev in forum: Re: HAVING prob !
• Thread view: Re: HAVING prob !

[Reply to this message]