﻿alter VIEW vGetTaf_ID_Of_DaryaftPardakht AS
	select d.ID,isnull(d.Taf_ID,0) Taf_ID from DaryaftPardakht d where isnull(d.Taf_ID,0) > 0 union all
	select d.ID,isnull(d.Taf_ID_BedehKar,0) Taf_ID from DaryaftPardakht d where isnull(d.Taf_ID_BedehKar,0) > 0 union all
	select d.ID,isnull(d.Taf_ID_BestanKar,0) Taf_ID from DaryaftPardakht d where isnull(d.Taf_ID_BestanKar,0) > 0 union all
	select d.ID,isnull(d.Taf_ID_Vat,0) Taf_ID from DaryaftPardakht d where isnull(d.Taf_ID_Vat,0) > 0 union all
	select d.ID,isnull(d.Taf_ID_Vat,0) Taf_ID from DaryaftPardakht d where isnull(d.Taf_ID_Wage,0) > 0 
