Select Stok.skodu,Stok.sadi,Stok.birim1,; Stok.barkod,depo.kod As depokodu,depo.tanim As depoadi,; NVL(CrsSatFat.toplamcikan,0) As toplamcikan,; NVL(CrsSatFat.SatisOrtFiyati,0) As SatisOrtFiyati,; NVL(CrsSatFat.SatisOrtTutari,0) As SatisOrtTutari,; NVL(CrsAlFat.toplamgiren,0) As toplamgiren,; NVL(CrsAlFat.AlisOrtFiyati,0) As AlisOrtFiyati,; NVL(CrsAlFat.AlisOrtTutari,0) As AlisOrtTutari,; CrsAlFatMax.sonalistarihi,NVL(CrsAlFatMax.sonalisfiyati,0),; NVL( Round( ( ( CrsSatFat.toplamcikan * CrsSatFat.SatisOrtFiyati ) - ; ( CrsSatFat.toplamcikan * CrsAlFat.AlisOrtFiyati ) ) / ; ( CrsSatFat.toplamcikan * CrsSatFat.SatisOrtFiyati ) * 100 , 2 ),0) As KarMarji,; NVL( ( CrsSatFat.toplamcikan * CrsSatFat.SatisOrtFiyati ) - ; ( CrsSatFat.toplamcikan * CrsAlFat.AlisOrtFiyati ),0) As OrtalamaKar; from Addbs(m.gcdata03)+'Stok'; left Join CrsSatFat On CrsSatFat.skodu=Stok.skodu; inner JOIN Addbs(m.gcdata03)+'depo' ON depo.kod=CrsSatFat.depokodu; left Join CrsAlFat On CrsAlFat.skodu=Stok.skodu ; inner Join CrsAlFatMax On CrsAlFatMax.skodu=Stok.skodu; ORDER By Stok.skodu; INTO Cursor CrsResult1