İlginiz için çok teşekkür ederim. Yardımınızla çözüme ulaştım artık null değer dönmüyor.
Kod: Tümünü seç
SELECT FINSAT410.SPI.SiparisDurumu, FINSAT410.CHK.Unvan1, FINSAT410.SPI.Tarih, FINSAT410.SPI.TahTeslimTarih,
FINSAT410.SPI.Kod7, FINSAT410.SPI.Aciklama, FINSAT410.SPI.Kod14, FINSAT410.SPI.Kod13, FINSAT410.STK.TipKod,
FINSAT410.SPI.Kod12 ,FINSAT410.SPI.Kod11,
coalesce(cast(FINSAT410.SPI.Kod11 as float),0)*coalesce(cast(FINSAT410.SPI.Kod12 as float),0) AS SiparisEdilenMetre,
coalesce(cast(FINSAT410.SPI.Kod11 as float),0)*coalesce(cast(FINSAT410.SPI.Kod12 as float),0)*coalesce(cast(FINSAT410.SPI.Kod14 as float),0)/100 AS SiparisEdilenM2,
coalesce(cast(FINSAT410.SPI.Kod11 as float),0)*coalesce(cast(FINSAT410.SPI.Kod12 as float),0)*coalesce(cast(FINSAT410.SPI.Kod14 as float),0)*coalesce(cast(FINSAT410.SPI.Kod13 as float),0)/1000 AS SiparisEdilenKG,
coalesce(cast(FINSAT410.STI.Kod11 as float),0)*coalesce(cast(FINSAT410.STI.Kod12 as float),0) AS TeslimEdilenMetre,
coalesce(cast(FINSAT410.STI.Kod11 as float),0)*coalesce(cast(FINSAT410.STI.Kod12 as float),0)*coalesce(cast(FINSAT410.STI.Kod14 as float),0)/100 AS TeslimEdilenM2,
coalesce(cast(FINSAT410.STI.Kod11 as float),0)*coalesce(cast(FINSAT410.STI.Kod12 as float),0)*coalesce(cast(FINSAT410.STI.Kod14 as float),0)*coalesce(cast(FINSAT410.STI.Kod13 as float),0)/1000 AS TeslimEdilenKG,
(coalesce(cast(FINSAT410.SPI.Kod11 as float),0)*coalesce(cast(FINSAT410.SPI.Kod12 as float),0))-(coalesce(cast(FINSAT410.STI.Kod11 as float),0)*coalesce(cast(FINSAT410.STI.Kod12 as float),0)) AS KalanMetre,
((coalesce(cast(FINSAT410.SPI.Kod11 as float),0)*coalesce(cast(FINSAT410.SPI.Kod12 as float),0)*coalesce(cast(FINSAT410.SPI.Kod14 as float),0))/100)-((coalesce(cast(FINSAT410.STI.Kod11 as float),0)*coalesce(cast(FINSAT410.STI.Kod12 as float),0)*coalesce(cast(FINSAT410.STI.Kod14 as float),0))/100) AS KalanM2,
(coalesce(cast(FINSAT410.SPI.Kod11 as float),0)*coalesce(cast(FINSAT410.SPI.Kod12 as float),0)*coalesce(cast(FINSAT410.SPI.Kod14 as float),0)*coalesce(cast(FINSAT410.SPI.Kod13 as float),0)/1000)-(coalesce(cast(FINSAT410.STI.Kod11 as float),0)*coalesce(cast(FINSAT410.STI.Kod12 as float),0)*coalesce(cast(FINSAT410.STI.Kod14 as float),0)*coalesce(cast(FINSAT410.STI.Kod13 as float),0)/1000) AS KalanKG,
FINSAT410.SPI.EvrakNo, FINSAT410.SPI.Kod1, FINSAT410.SPI.IslemTur
FROM ((FINSAT410.SPI LEFT JOIN FINSAT410.STK ON FINSAT410.SPI.MalKodu = FINSAT410.STK.MalKodu)
LEFT JOIN FINSAT410.CHK ON FINSAT410.SPI.Chk = FINSAT410.CHK.HesapKodu) LEFT JOIN FINSAT410.STI ON
(FINSAT410.SPI.Tarih = FINSAT410.STI.Tarih) AND (FINSAT410.SPI.SiraNo = FINSAT410.STI.SiraNo) AND
(FINSAT410.SPI.IslemTur = FINSAT410.STI.IslemTur) AND (FINSAT410.SPI.EvrakNo = FINSAT410.STI.EvrakNo) AND
(FINSAT410.SPI.Chk = FINSAT410.STI.Chk)
WHERE (((FINSAT410.SPI.IslemTur)=1));
Teşekkürler.