alter VIEW [dbo].[Anroid_art_gardesh]
AS
SELECT        dbo.art_gardesh.custno, CASE WHEN dbo.art_gardesh.money1 >= 0 THEN dbo.art_gardesh.money1 ELSE 0 END AS Bed, 
                         CASE WHEN dbo.art_gardesh.money1 < 0 THEN dbo.art_gardesh.money1 * - 1 ELSE 0 END AS Bes, dbo.customer.name, 
                         dbo.customer.type AS Type
FROM            dbo.art_gardesh LEFT OUTER JOIN
                         dbo.customer ON dbo.art_gardesh.custno = dbo.customer.custno
						 where dbo.art_gardesh.custno <> 0
