stok bakiyelerini eklemek?

[recer]

create view FiyatGor as
select BARCODE as barkod,NAME as isim,convert(varchar(20),PRICE) as fiyat,CURCODE as doviz from LG_002_PRCLIST Fyt,LG_002_UNITBARCODE Brcd,LG_002_ITEMS Stk,L_CURRENCYLIST Pb
WHERE
pb.CURTYPE= Fyt.CURRENCY
and Fyt.CARDREF=Stk.LOGICALREF and Fyt.PTYPE = 2
and Brcd.ITEMREF=stk.LOGICALREF

bu kod ile malzeme fiyat ve adlarını çekebiliyorum. bu koda malzeme miktar bakiyelerini de çekmek isitiyorum bunu nasıl yaparım.

[halisbatmaz]

bende az evvel bunu yaptım
SELECT M.CODE AS 'KODU', M.NAME AS 'ÜRÜN ADI', M.STGRPCODE AS 'GRUP', F.PRICE AS 'FİYAT', D.ONHAND AS 'MİKTAR'
FROM LKSDB.dbo.LG_008_05_GNTOTST D, LKSDB.dbo.LG_008_PRCLIST F, LKSDB.dbo.LG_008_ITEMS M
WHERE M.LOGICALREF = F.CARDREF AND M.LOGICALREF = D.STOCKREF AND ((F.PTYPE=2) AND (F.GRPCODE='1') AND (F.ACTIVE=0) AND (D.INVENNO=0))

[recer]

TEŞEKKÜRLER bene yapmışdım zaten

select BARCODE as barkod,NAME as isim,convert(varchar(20),PRICE) as fiyat,ONHAND as miktar, CURCODE as doviz from LG_001_PRCLIST Fyt,LG_001_UNITBARCODE Brcd,LG_001_ITEMS Stk,L_CURRENCYLIST Pb,lg_001_01_GNTOTST mik
WHERE
pb.CURTYPE= Fyt.CURRENCY
and Fyt.CARDREF=Stk.LOGICALREF and Fyt.PTYPE = 2
and Brcd.ITEMREF=stk.LOGICALREF
and mik.STOCKREF=stk.LOGICALREF

[ByBirol®]

Bu kod hatalı sonuç döndürüyor .

[recer]

doğrudur lg_001_01_GNTOTST lv_001_01_gntotst olcak.