USE TIGERDB
select LOGICALREF,CODE,NAME,
(select (LV_115_01_GNTOTST.ONHAND-LV_115_01_GNTOTST.RESERVED) FROM LV_115_01_GNTOTST WHERE LV_115_01_GNTOTST.STOCKREF=LG_115_ITEMS.LOGICALREF AND LV_115_01_GNTOTST.INVENNO=-1) AS STOK,
(select logomx.dbo.ProductDesc.ProductDesc from logomx.dbo.ProductDesc where logomx.dbo.ProductDesc.CustomerID=102 and logomx.dbo.ProductDesc.CODE=LG_115_ITEMS.CODE) AS DETAY
from LG_115_ITEMS where ACTIVE=0 AND CARDTYPE=1 AND IMAGEINC=1
SQLDE CALISYOR FAKAT C# SqlCommand DE " Incorrect syntax near" HATASI VERIYOR
Toplam 0 cevap