SentezVogue Sipariş Fiş Listesi SQL Sorgusu
Select S.FISNO as [Fiş No],S.TARIH as [Sipariş Tarihi],isnull(C.ADI,S.CKOD) as [Cari Adı]
,isnull(M.ADI,S.MKOD) as [Stok Açıklama],S.VRNT1 as [Varyant1],S.VRNT2 as [Varyant2]
,S.MIKTAR as [Miktar],isnull(M.BRM1,'') as [Birim],S.FIYAT as [Birim Fiyat],(S.MIKTAR*S.FIYAT) as [Tutar]
,S.TIP as [Hareket Tipi]
from SIPFD S
left join MUSTERI C on (C.KOD=S.CKOD)
left join MAL M on (M.KOD=S.MKOD)
order by S.TIP,S.FISNO