>***Some interface consideration: in many cases it's not necessarily to make all calculations, joints inside the SELECT-SQL. They might be done faster by interface means. It depends on how you're planning to use this view.****
>Yeah, I got it, but I have to include all the calculation inside, because some of the calculated value are unstable (changed all the times).
It doesn't matter how often values will be cxhanged. I meant that you move calculations from SQL to e.g. grid.column.controlsources, if you put result to grid.
Edward Pikman
Independent Consultant