select distinct tserviceid.serviceid,
       tn.batchid, tbatchtype.description
from tfinalisedtransaction201004 tn, tserviceid, tbatch, tbatchtype
where tn.serviceid = tserviceid.id
  and tn.batchid = tbatch.id
  and tbatch.batchtypeid = tbatchtype.id
order by tserviceid.serviceid, tn.batchid