>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 >