Merhaba,
SELECT IT.CODE AS MALZKOD, IT.NAME AS MALZACIKLAMA, SUM(REMAMOUNT) AS MIKTAR,SER.CODE AS LOTNO,
ISNULL(ISNULL(ISNULL((SELECT TOP (1) X.DATE_ FROM LG_001_01_SLTRANS X LEFT JOIN LG_001_01_SERILOTN Y ON X.SLREF=Y.LOGICALREF WHERE SER.CODE=Y.CODE ORDER BY X.DATE_ ASC),(SELECT TOP (1) X.DATE_ FROM LG_002_01_SLTRANS X LEFT JOIN LG_002_01_SERILOTN Y ON X.SLREF=Y.LOGICALREF WHERE SER.CODE=Y.CODE ORDER BY X.DATE_ ASC)),(SELECT TOP (1) X.DATE_ FROM LG_003_01_SLTRANS X LEFT JOIN LG_003_01_SERILOTN Y ON X.SLREF=Y.LOGICALREF WHERE SER.CODE=Y.CODE ORDER BY X.DATE_ ASC)),(SELECT TOP (1) X.DATE_ FROM LG_004_01_SLTRANS X LEFT JOIN LG_004_01_SERILOTN Y ON X.SLREF=Y.LOGICALREF WHERE SER.CODE=Y.CODE ORDER BY X.DATE_ ASC))
FROM LG_004_01_SLTRANS AS SLT
LEFT JOIN LG_004_ITEMS AS IT ON SLT.ITEMREF=IT.LOGICALREF
LEFT JOIN LG_004_01_STLINE AS STL ON SLT.STTRANSREF=STL.LOGICALREF
LEFT JOIN LG_004_01_SERILOTN AS SER ON SLT.SLREF=SER.LOGICALREF
WHERE STL.SOURCEINDEX=0
GROUP BY SLT.ITEMREF, IT.CODE, IT.NAME, SER.CODE
Uzun bir ISNULL sarmalında kaldı ama bende sonuç verdi yukarıdaki gibi