Eski sorgularım dan, fakat biraz üzerinde çalışman lazım. (SON HAREKET TARİHLERİ)
SELECT A.CODE AS Kodu, A.NAME AS ACIKLAMA,
B.LASTTRDATE AS SHTarihi
FROM LG_001_ITEMS AS A INNER JOIN
LG_001_01_GNTOTST AS B ON A.LOGICALREF = B.STOCKREF
GROUP BY A.CODE, A.NAME, B.LASTTRDATE
ORDER BY Kodu, SHTarihi