select distinct kala.code,kala.name, sum(case when (dbo.tblInvVoucher.VType = 'ran') then dbo.tblInvArticle.Amount end) as رسید, sum(case when (dbo.tblInvVoucher.VType = 'han') then dbo.tblInvArticle.Amount end) as حواله ,sum(case when (dbo.tblInvVoucher.VType = 'mda') then dbo.tblInvArticle.Amount end) as [موجودی اولیه] from dbo.tblInvArticle,dbo.tblInvVoucher,kala where tblInvArticle.VId=tblInvVoucher.VId and kala.code=tblInvArticle.GoodId and FYear='1392' group by code,name
iif([S].[Gender] = 1,'Male',iif([S].[Gender]=2,'Female','Other')) as [Gender]
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)