>>>>>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