Select TranName,TranAmount,TranRecord from
(Select TranName,TranCode from TranType ) a ,
(select TranCode ,Sum(tranAmount) TranAmount from TranRec Group by TranCode) b,
(select TranCode ,Count(*),TranRecord from TranRec Group by TranCode) c
where a.TranCode = b.TranCode and a.TranCode = c.TranCode