>>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>
If it's not broken, fix it until it is.
My Blog