SELECT VoucherCode, TotalServiceCost, *
FROM ShippingOrder
WHERE OrderCode = (
	select order_code
        FROM abc
        WHERE id = xyz
)