CARİ HESAPLARIN SON İŞLEM TARİHİNE GÖRE RAPORLANMASI

[oktaybickici]

BU KODA CARİ HESAPLARIN CARİ KODLARINI NASIL EKLEYEBİLİRİM İLAVE OLARAK. BU RAPORDA SADECE CARİ İSİMLERİ GELİYOR. BUNLARIN BAŞINA CARİ HESAP KODLARINI KOYMAK İSTİYORUM. TEŞEKKÜRLER.
SELECT
C.DEFINITION_,
MAX(L2.[DATE_])AS SON_İŞLEM_TARİHİ_2015,
MAX(L3.[DATE_])AS SON_İŞLEM_TARİHİ_2016,
MAX(L4.[DATE_])AS SON_İŞLEM_TARİHİ_2017

FROM [LG_022_CLCARD] C
full outer JOIN LG_022_02_CLFLINE L2 ON L2.CLIENTREF=C.LOGICALREF
full outer JOIN LG_022_03_CLFLINE L3 ON L3.CLIENTREF=C.LOGICALREF
full outer JOIN LG_022_04_CLFLINE L4 ON L4.CLIENTREF=C.LOGICALREF
GROUP BY C.DEFINITION_, C.CODE
ORDER BY C.CODE

[Teknik21]

 

SELECT

C.CODE ,
C.DEFINITION_,
MAX(L2.[DATE_])AS SON_İŞLEM_TARİHİ_2015,
MAX(L3.[DATE_])AS SON_İŞLEM_TARİHİ_2016,
MAX(L4.[DATE_])AS SON_İŞLEM_TARİHİ_2017

FROM [LG_022_CLCARD] C
full outer JOIN LG_022_02_CLFLINE L2 ON L2.CLIENTREF=C.LOGICALREF
full outer JOIN LG_022_03_CLFLINE L3 ON L3.CLIENTREF=C.LOGICALREF
full outer JOIN LG_022_04_CLFLINE L4 ON L4.CLIENTREF=C.LOGICALREF
GROUP BY C.DEFINITION_, C.CODE
ORDER BY C.CODE

[oktaybickici]

ÇOK TEŞEKKÜRLER. İŞLEM TAMAM 9 DAKİKADA SORGU ÇIKTI.