hi,
it works now,
but i have no reasion why it did not work before.

thank you very much for concern and follow up.


>>hi,
>>thank you for reply,
>>Though in your case it may be better to add these fields to GROUP BY? yes
>>
>>
>
>You didn't answer on my question how did you get an error with
>SET ENGINEBEHAVIOR 70