---------
SELECT
PRO.CODE AS 'Proje Kodu',ITM.CODE AS 'Hammaddde Kodu', ITM.NAME AS 'Hammadde Açıklaması',STF.DATE_ AS 'Tarih',STF.FICHENO AS 'Fiş No',
STL.AMOUNT AS 'Reçete Miktarı',STL.SOURCEINDEX AS 'Çıkış Ambarı'
FROM LG_050_02_STLINE STL JOIN LG_050_ITEMS ITM
ON ITM.LOGICALREF = STL.STOCKREF JOIN LG_050_PROJECT PRO
ON PRO.LOGICALREF = STL.PROJECTREF JOIN LG_050_02_STFICHE STF
ON STF.LOGICALREF = STL.STFICHEREF
WHERE STL.CANCELLED = 0 AND STL.LINETYPE = 0 AND STL.LPRODSTAT = 0 AND PRO.CODE IS NOT NULL AND ITM.CODE LIKE 'KMS%'
ORDER BY PRO.CODE
-------------
Bu kadar kod yazdım yardım edin bitsin bari şu sorgu