Dear Experts,

I have 3 master tables and 1 tranasaction table

In transaction table conatines eigther on of the code from Master file code or empty code;
my purpose is while retriving data from Transaction Table i want to display description from master
file with respect of the code from trasction table and if code is empty i want disply as 'CASH'.
how i will do this in Sql Server.

Master file 1 Stock. Master file 2 NonStock. Master file 3 General.

STCODE1 NSTCODE1 GENCODE1
STDESCRI NSTDESCRI GENDESCRI

STCODE2 NSTCODE2 GENCODE2
STDESCR2 NSTDESCR2 GENDESCR2

Transaction file

TrsInv TrsCode Amt Qty

INV001 STCODE1 5 7
INV001 STCODE2 2 8
INV001 GENCODE2 8 4
INV001 NSTCODE1 8 4
INV001 6 9
INV001 NSTCODE2 8 3

Thanks in Advance

Abdulla