>>The column MYCNT does not exist, it's created by aggregate function. As such it should be checked in HAVING clause.

>>...
>>HAVING MYCNT > 1
>>...
>>

>>
>
>Thank you very much.

And that's what you're getting when you decided to work a little <g> 49 seconds later and no star <g>