alter VIEW vGetTaf_ID_Of_Salary AS select sr.ID , sr.Taf_ID from SalaryReceipt sr inner join SalaryReceiptItem sri on sr.ID = sri.SR_ID where isnull(sr.Taf_ID ,0) > 0 union all select sr.ID , sr.Taf_ID_Insurance from SalaryReceipt sr inner join SalaryReceiptItem sri on sr.ID = sri.SR_ID where isnull(sr.Taf_ID_Insurance ,0) > 0 union all select sr.ID , sr.Taf_ID_SalaryCost from SalaryReceipt sr inner join SalaryReceiptItem sri on sr.ID = sri.SR_ID where isnull(sr.Taf_ID_SalaryCost ,0) > 0 union all select sr.ID , sr.Taf_ID_Tax from SalaryReceipt sr inner join SalaryReceiptItem sri on sr.ID = sri.SR_ID where isnull(sr.Taf_ID_Tax ,0) > 0