Merhaba;
İstemiş olduğunuz bilgileri aşağıdaki Query ile alabilirsiniz.
SELECT dbo.LG_209_PRODORD.FICHENO AS FİŞ_NO, dbo.LG_209_PRODORD.DATE_ AS FİŞ_TARİHİ, dbo.LG_209_PRODORD.FACTORYNR AS FABRİKA_NO,
dbo.LG_209_ITEMS.CODE AS MALZEME_KODU, dbo.LG_209_ITEMS.NAME AS [MALZ<EME_ADI],
dbo.LG_209_PRODORD.PLNAMOUNT AS PLANLANAN_MİKTAR, dbo.LG_209_PRODORD.ACTAMOUNT AS GERÇEKLEŞEN_MIKTAR,
dbo.LG_209_PRODORD.PLNBEGDATE AS PLN_BASLLANGIC, dbo.LG_209_PRODORD.PLNENDDATE AS PLN_BITIS,
dbo.LG_209_PRODORD.ACTBEGDATE AS GERC_BASLANGIC, dbo.LG_209_PRODORD.ACTENDDATE AS GERC_BITIS,
MONTH(dbo.LG_209_PRODORD.ACTENDDATE) AS AY, YEAR(dbo.LG_209_PRODORD.ACTENDDATE) AS YIL
FROM dbo.LG_209_PRODORD INNER JOIN
dbo.LG_209_ITEMS ON dbo.LG_209_PRODORD.ITEMREF = dbo.LG_209_ITEMS.LOGICALREF