selamlar,
SQL
USE TIGER
SELECT t3.urun,t3.BOMREVREF,sum(t3.TOPLAM) AS TOPLAM FROM
(
SELECT *,t2.ort_fiyat*T1.AMOUNT AS TOPLAM FROM
(
SELECT Lg_099_bomline.LINETYPE, Lg_099_items.CODE AS STOKADi ,Lg_099_items.NAME, Lg_099_items.SPECODE, Lg_099_unitsetl.CODE,
Lg_099_bomline.AMOUNT, Lg_099_bomline.BOMREVREF, Lg_099_bomaster.CAPIBLOCK_MODIFIEDDATE,
Lg_099_items.LOGICALREF, LG_099_BOMASTER.code AS urun,Lg_xt1001_099.*
FROM dbo.LG_099_BOMLINE Lg_099_bomline
LEFT OUTER JOIN dbo.LG_099_ITEMS Lg_099_items
ON Lg_099_bomline.ITEMREF = Lg_099_items.LOGICALREF
LEFT OUTER JOIN dbo.LG_XT1001_099 Lg_xt1001_099
ON Lg_099_bomline.ITEMREF = Lg_xt1001_099.PARLOGREF
LEFT OUTER JOIN dbo.LG_099_BOMASTER Lg_099_bomaster
ON Lg_099_bomline.BOMREVREF = Lg_099_bomaster.VALIDREVREF
LEFT OUTER JOIN dbo.LG_099_UNITSETL Lg_099_unitsetl
ON Lg_099_bomline.UOMREF = Lg_099_unitsetl.LOGICALREF
WHERE LEN(Lg_099_bomaster.CODE)>0 AND Lg_099_bomline.LINETYPE=0
) t1
LEFT OUTER JOIN
(
SELECT Lg_099_12_gntotst.STOCKREF,Lg_099_12_gntotst.AVGVALUE AS ort_fiyat
FROM dbo.LG_099_12_gntotst
WHERE Lg_099_12_gntotst.INVENNO = ( 0 )
) t2
ON t1.LOGICALREF=t2.STOCKREF
) t3
GROUP BY t3.BOMREVREF,t3.urun
ORDER BY t3.BOMREVREF
yukarıdaki kod doğru ve sorunsuz çalışmaktadır (bence)
Sorum şu: sonuç 3 kolon olarak çıkıyor. urun,BOMREVREF ve TOPLAM ben ise (Lg_099_bomline.LINETYPE, Lg_099_items.CODE AS STOKADi ,Lg_099_items.NAME, Lg_099_items.SPECODE, Lg_099_unitsetl.CODE,
Lg_099_bomline.AMOUNT, Lg_099_bomline.BOMREVREF, Lg_099_bomaster.CAPIBLOCK_MODIFIEDDATE,
Lg_099_items.LOGICALREF, LG_099_BOMASTER.code as urun,Lg_xt1001_099.*) bunlardan bir veya birkaçını 4,5,6.. kolon olarak koymak isitiyorum ama 4,5,6... kolonları guruplamak istemiyorum. Nasıl yapabilirim. VFP dakigibi yani.
Umarım anlatabilmişimdir.
Ek Olarak.
Sonuç hata veriyor anlamı nedir!
Warning: Null value is eliminated by an aggregate or other SET operation.
(2501 row(s) affected)
Bilmediğin Neyse Yanıldığındır.