I was suggesting exactly what you just came up by yourself. I just didn't have time to explain it in more details.

>I'm not sure I understand what you are suggesting. How do I calculate the mycalcfield? I think I'm missing what you're saying?
>
>>You can try
>>

>>select *, myCalcField from (your select statement) myInnerSelect

>>