Posted by markc600 on 06/02/06 12:10

SELECT Mat,
'd' AS Dur
FROM MAND
GROUP BY Mat
HAVING COUNT(*)=2 AND COUNT(DISTINCT Dur)=1

• Next in forum: Re: HAVING prob !
• Prev in forum: Re: HAVING prob !
• Thread view: Re: HAVING prob !

[Reply to this message]