que

SELECT top 50 VOUCHERCODE FROM TBS_VOUCHERMANAGEMENTDETAILS a
JOIN TBS_VOUCHERMANAGEMENTHEADER b on b.RC_CODE = a.RC_CODE
WHERE VOUCHERAMOUNT = 50000 and TBS_VMSDETAIL_STATUS = 2 and ACTIVATIONDATE <= GETDATE() AND EXPIRYDATE >= GETDATE()
and b.TBS_VOUCHERTYPE = 0