Hi,
Try joining
SELECT A.order_type, sum(A.order_value) AS "Total", B.Description
FROM tpayment_order A, order_status_ref B
WHERE A.order_type=B.order_type
GROUP BY order_type, order_status_ref
But a vital assumption is that the order_status_ref is table with the following mapping:
order_type | Description
Without this mapping, the joining would be meaningless.
*Mark as answer if this solves your query.