CREATE OR ALTER VIEW TBLELZABFIYATGOR(
    BARKOD,
    ISIM,
    FIYAT,
    PB1)
AS
select ubarkod as barkod,uad as isim, usonsatfiy as fiyat, 'TL' as PB1 from urunler  where usonsatfiy>0
union all
Select obrk2 as barkod,uad as isim, usonsatfiy as fiyat, 'TL' as PB1 from urunler where usonsatfiy>0
;