select
cast(s.k as varchar(10)) || ';' || s.ad || ';' || b.ad || ';' ||
cast(sf.psatisfiyat as varchar(20)) || ';' || cast(sf.alisfiyatisk as varchar(20)) || ';' || cast(pkdv.oran as varchar(20)) || ';' || sk.ad || ';' ||
(select list(barkod,';') from vstokbarkod where stok_k=s.k)
from stok s
join birim b on s.birim_k=b.k
join kdv pkdv on s.perakende_kdv_k=pkdv.k
join stokfiyat sf on sf.stok_k=s.k and sf.konum_k=2
join stokkategori sk on s.stokkategori_k=sk.k
1 Beğeni