USE TABLE_01
select Trans_ID, code, COUNT(TRANS_ID+CODE) AS COMB ;
From TABLE_01;
GROUP BY TRANS_ID,CODE ;
INTO TABLE Table_02
select Trans_ID, code,COMB,COUNT(COMB) AS TOT_ITM ;
From TABLE_02;
GROUP BY TRANS_ID ;
INTO TABLE Table_03
USE
USE TABLE_03
BROWSE
**********FINAL...