1)
select C.Vouc_No,C.Vouc_Date,V.Vouc_Name,M.Dr_Amt
from ActTranhead C
inner join ActTrans M on C.Head_Id=M.Head_Id and M.DrAcc_Id=3
inner join Vouc_Types V on V.VoucType_Id= C.Vouc_TypeId
2)
select M.Cr_Amt
from ActTranhead C
inner join ActTrans M on C.Head_Id=M.Head_Id and M.CrAcc_Id=3
inner join Vouc_Types V on V.VoucType_Id= C.Vouc_TypeId
output:
Vouc_No,Vouc_Date,Vouc_Name,Dr_Amt,Cr_Amt
Go to the complete details ...