ÜRETİM HAREKETLERİNİ ALMAK İÇİN BU SORGUYU OLUŞTURDUM AMA 14.04.2010 DAN SONRA DB DE HİÇ BİR ŞEY DÖKMÜYOR
NEDEN ACABA ?
SELECT TOP 100 PERCENT dbo.LG_100_ITEMS.CODE, dbo.LG_100_ITEMS.NAME, dbo.LG_100_04_STLINE.DATE_, dbo.LG_100_04_STLINE.CLIENTREF,
dbo.LG_100_04_STLINE.INVOICEREF, dbo.LG_100_04_STLINE.AMOUNT, dbo.LG_100_04_STLINE.PRICE, dbo.LG_100_04_STLINE.TOTAL,
dbo.LG_100_04_STLINE.STATUS, dbo.LG_100_04_STLINE.STFICHELNNO
FROM dbo.LG_100_04_STLINE INNER JOIN
dbo.LG_100_ITEMS ON dbo.LG_100_04_STLINE.LOGICALREF = dbo.LG_100_ITEMS.LOGICALREF
ORDER BY dbo.LG_100_04_STLINE.DATE_ DESC