Stok kartlarinda alt sorgulama yapiyorum fakat alt sorgu olacak bilgi baska database bu nedenle hata aliyorum, MS-SQL serverda bu mumkunmudur...
Query su sekildedir....
Kod: Tümünü seç
SELECT
LOGICALREF,
(Select CODE From Aqua_40.Dbo.VT_ITEMS Where (LOGICALREF=STLINE.STOCKREF)) AS Stok_kodu,
(Select PRODUCERCODE From Aqua_40.Dbo.VT_ITEMS Where (LOGICALREF=STLINE.STOCKREF)) AS Kod_Ram,
(Select NAME From Aqua_40.Dbo.VT_ITEMS Where (LOGICALREF=STLINE.STOCKREF)) AS Aciklama,
(Select NAME_RU From Aqua_40_RU.Dbo.ITEMS_RU Where (CODE_NEW=(Select CODE From Aqua_40.Dbo.VT_ITEMS Where (LOGICALREF=STLINE.STOCKREF)))) AS Aciklama_ru,
AMOUNT as Miktar, PRICE as Fiyat, TOTAL
FROM Aqua_40.dbo.VT_01_STLINE AS STLINE
WHERE (STLINE.STFICHEREF=:LOGICALREF)
ORDER by INVOICELNNO
Kod: Tümünü seç
(Select NAME_RU From Aqua_40_RU.Dbo.ITEMS_RU Where (CODE_NEW=(Select CODE From Aqua_40.Dbo.VT_ITEMS Where (LOGICALREF=STLINE.STOCKREF)))) AS Aciklama_ru,
Burhan Cakmak