Kullana bileceğiniz bazı SQL fonksiyonları ;
SELECT LG_086_ITEMS.CODE AS [Stok Kodu], LG_086_ITEMS.NAME AS [Stok Adı], LG_086_PRCLIST.PTYPE AS [Fiyat Türü], LG_086_PRCLIST.PRICE AS Fiyat,
LG_086_ITEMS.ACTIVE AS Statü, LG_086_PRCLIST.BEGDATE AS Başlangıç, LG_086_PRCLIST.ENDDATE AS Bitiş,
LG_086_PRCLIST.CYPHCODE AS [Yetki Kodu]
FROM LG_086_ITEMS INNER JOIN
LG_086_PRCLIST ON LG_086_ITEMS.LOGICALREF = LG_086_PRCLIST.CARDREF
WHERE (LG_086_ITEMS.CODE LIKE '%CA.VNK%') AND (LG_086_ITEMS.ACTIVE = 0)
