Merhaba,
kabaca rapor kodu şu şekilde (212 yerine kendi firma numaranı yazacaksın)
SELECT I.CODE KODU
,I.NAME ADI
,B.BARCODE
,PA.PRICE ALIS_FIYATI
,PS.PRICE SATIS_FIYATI
FROM LG_212_ITEMS I
LEFT OUTER JOIN LG_212_UNITBARCODE B ON B.ITEMREF =I.LOGICALREF
LEFT OUTER JOIN LG_212_PRCLIST PA ON PA.CARDREF=I.LOGICALREF AND PA.PTYPE=1
LEFT OUTER JOIN LG_212_PRCLIST PS ON PS.CARDREF=I.LOGICALREF AND PS.PTYPE=2