SELECT URUNMS.CODE 'Sınıf Kodu',URUNMS.NAME 'Sınıf Adı',URUN2.CODE 'Ürün Kodu',URUN2.NAME 'Ürün Adı',
HRK.DATE_ 'Tarih',HRK.AMOUNT 'Miktar',BIRIM.CODE 'Birim'
FROM LG_XXX_ITEMS URUNMS
INNER JOIN LG_XXX_ITMCLSAS SINIFBAGLANTI ON URUNMS.LOGICALREF=SINIFBAGLANTI.PARENTREF
INNER JOIN LG_XXX_ITEMS URUN2 ON SINIFBAGLANTI.CHILDREF=URUN2.LOGICALREF
INNER JOIN LG_XXX_01_STLINE HRK ON URUN2.LOGICALREF=HRK.STOCKREF AND HRK.TRCODE=13
INNER JOIN LG_XXX_UNITSETL BIRIM ON HRK.UOMREF=BIRIM.LOGICALREF
WHERE URUNMS.CARDTYPE=20