***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).
Anyway, what the speed for this SQL-Select in VFP5.0 is faster than in 6.0
Senna Dwipayana
Being good is better
Being better is a bless