Kategori arşivi: Genel

Logo Tiger Muhasebe Kodu Olmayan Stoklar

Posted on by 
 SELECT  CODE, NAME,
(SELECT COUNT(*) FROM [dbo].[LG_001_CRDACREF]
WHERE TRCODE = 1 AND CARDREF =dbo.LG_001_ITEMS.LOGICALREF) AS SAY
FROM dbo.LG_001_ITEMS
WHERE (SELECT COUNT(*) FROM [dbo].[LG_001_CRDACREF]
WHERE TRCODE = 1 AND CARDREF =dbo.LG_001_ITEMS.LOGICALREF) <1
Genel kategorisine gönderildi