Is it possible for TransactionID to be duplicated in the table GV_Voucher?
If the answer is No, then you can fetch it based on VoucherNo's else you will need TransactionID in both the tables.
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/