XXX Yazan yerlere kendi firma Numarasını yazın. Birde bende " K " ile başlayan stoklara göre raporlama yapıyor onuda iptal edin veya kendinize uygun hale getirin.
SELECT LG_XXX_ITEMS.CODE AS 'KODU', LG_XXX_ITEMS.NAME, LG_XXX_ITEMS.SPECODE AS 'ÖZELKOD', LG_XXX_ITEMS.ACTIVE, LG_XXX_ITEMS.CLASSTYPE, LG_XXX_PRCLIST.PRICE AS 'FİYAT', LG_XXX_PRCLIST.MTRLTYPE AS 'ÖNCELİK', LG_XXX_PRCLIST.PTYPE AS 'FİYAT TİPİ'
FROM LOGO.dbo.LG_XXX_ITEMS LG_XXX_ITEMS, LOGO.dbo.LG_XXX_PRCLIST LG_XXX_PRCLIST
WHERE LG_XXX_ITEMS.LOGICALREF = LG_XXX_PRCLIST.CARDREF AND ((LG_XXX_ITEMS.CODE Like 'K%'))
ORDER BY LG_XXX_ITEMS.CODE