>>>>select Numbers.Number, X.* from Numbers ; >>>>INNER JOIN (...) X ; >>>>ON ...>>>>
SELECT TAlias1.no,TAlias1.column3,TAlias1.sum1,TAlias1.total,TAlias2.ncount; FROM a1 TAlias1, mas TAlias2 ; WHERE TAlias1.column3= TAlias2.column3 INTO cursor TAliascursor1 nofilter select * from tAliasCursor1 where 1= 0 into curFinalResult readwrite select tAliasCursor1 scan scatter memvar for i=1 to nCount insert into curFinalResult from memvar next endscan select curFinalResult browse