i have query like this
First Column accnum 111,112 ,113 , 121,122,123
Send Column Debit 700,500,0 200,900,100
Third Column Credit 400,200,0 100,800,600
_____________________________________________________________________________________
So Question is
i need to make Fourth cloumn in query contain only values that have accnum like 111,112,113
i has to appear like 700,500 only
First Column accnum 111,112 ,113 , 121,122,123
Send Column Debit 700,500,0 200,900,100
Third Column Credit 400,200,0 100,800,600
_____________________________________________________________________________________
So Question is
i need to make Fourth cloumn in query contain only values that have accnum like 111,112,113
i has to appear like 700,500 only