SELECT a.terminalid,a.Transactionid,a.staff,c.NAMEONRECEIPT,a.amount,a.createddatetime
FROM crt.SALESTRANSACTION a inner join RETAILSTAFFTABLE c on a.STAFF=c.STAFFID
where  ISSUSPENDED = 1 AND DELETEDDATETIME is NULL ORDER BY A.createddatetime