pythontr.com
Select AIR_ALS_ANA_HSIRKET AS HAVA_SIRKETI, (Case When :CHRQ_WEIGHT >= 45 and :CHRQ_WEIGHT < 100 then 45 When :CHRQ_WEIGHT >= 100 and :CHRQ_WEIGHT < 200 then 100 When :CHRQ_WEIGHT >= 200 and :CHRQ_WEIGHT < 250 then 200 When :CHRQ_WEIGHT >= 250 and :CHRQ_WEIGHT < 300 then 250 When :CHRQ_WEIGHT >= 300 and :CHRQ_WEIGHT < 500 then 300 When :CHRQ_WEIGHT >= 500 and :CHRQ_WEIGHT < 1000 then 500 When :CHRQ_WEIGHT >= 1000 and :CHRQ_WEIGHT < 1500 then 1000 When :CHRQ_WEIGHT >= 1500 and :CHRQ_WEIGHT < 2000 then 1500 When :CHRQ_WEIGHT >= 2000 and :CHRQ_WEIGHT < 2500 then 2000 When :CHRQ_WEIGHT >= 2500 and :CHRQ_WEIGHT < 3000 then 2500 When :CHRQ_WEIGHT >= 3000 and :CHRQ_WEIGHT < 5000 then 3000 When :CHRQ_WEIGHT >= 5000 then 5000 else 0 end) as BAREM, (Case When :CHRQ_WEIGHT >= 45 and :CHRQ_WEIGHT < 100 then AIR_ALS_DET_45 When :CHRQ_WEIGHT >= 100 and :CHRQ_WEIGHT < 200 then AIR_ALS_DET_100 When :CHRQ_WEIGHT >= 200 and :CHRQ_WEIGHT < 250 then AIR_ALS_DET_200 When :CHRQ_WEIGHT >= 250 and :CHRQ_WEIGHT < 300 then AIR_ALS_DET_250 When :CHRQ_WEIGHT >= 300 and :CHRQ_WEIGHT < 500 then AIR_ALS_DET_300 When :CHRQ_WEIGHT >= 500 and :CHRQ_WEIGHT < 1000 then AIR_ALS_DET_500 When :CHRQ_WEIGHT >= 1000 and :CHRQ_WEIGHT < 1500 then AIR_ALS_DET_1000 When :CHRQ_WEIGHT >= 1500 and :CHRQ_WEIGHT < 2000 then AIR_ALS_DET_1500 When :CHRQ_WEIGHT >= 2000 and :CHRQ_WEIGHT < 2500 then AIR_ALS_DET_2000 When :CHRQ_WEIGHT >= 2500 and :CHRQ_WEIGHT < 3000 then AIR_ALS_DET_2500 When :CHRQ_WEIGHT >= 3000 and :CHRQ_WEIGHT < 5000 then AIR_ALS_DET_3000 When :CHRQ_WEIGHT >= 5000 then AIR_ALS_DET_5000 else 0 end) as RATE, (Case When :CHRQ_WEIGHT >= 45 and :CHRQ_WEIGHT < 100 then AIR_ALS_DET_45 * :CHRQ_WEIGHT When :CHRQ_WEIGHT >= 100 and :CHRQ_WEIGHT < 200 then AIR_ALS_DET_100 * :CHRQ_WEIGHT When :CHRQ_WEIGHT >= 200 and :CHRQ_WEIGHT < 250 then AIR_ALS_DET_200 * :CHRQ_WEIGHT When :CHRQ_WEIGHT >= 250 and :CHRQ_WEIGHT < 300 then AIR_ALS_DET_250 * :CHRQ_WEIGHT When :CHRQ_WEIGHT >= 300 and :CHRQ_WEIGHT < 500 then AIR_ALS_DET_300 * :CHRQ_WEIGHT When :CHRQ_WEIGHT >= 500 and :CHRQ_WEIGHT < 1000 then AIR_ALS_DET_500 * :CHRQ_WEIGHT When :CHRQ_WEIGHT >= 1000 and :CHRQ_WEIGHT < 1500 then AIR_ALS_DET_1000 * :CHRQ_WEIGHT When :CHRQ_WEIGHT >= 1500 and :CHRQ_WEIGHT < 2000 then AIR_ALS_DET_1500 * :CHRQ_WEIGHT When :CHRQ_WEIGHT >= 2000 and :CHRQ_WEIGHT < 2500 then AIR_ALS_DET_2000 * :CHRQ_WEIGHT When :CHRQ_WEIGHT >= 2500 and :CHRQ_WEIGHT < 3000 then AIR_ALS_DET_2500 * :CHRQ_WEIGHT When :CHRQ_WEIGHT >= 3000 and :CHRQ_WEIGHT < 5000 then AIR_ALS_DET_3000 * :CHRQ_WEIGHT When :CHRQ_WEIGHT >= 5000 then AIR_ALS_DET_5000 * :CHRQ_WEIGHT else 0 end) as NAVLUN, AIR_ALS_ANA.* from AIR_ALS_ANA JOIN AIR_ALS_DET ON AIR_ALS_ANA.AIR_ALS_ANA_RECNO = AIR_ALS_DET.AIR_ALS_ANA_RECNO where AIR_ALS_ANA.AIR_ALS_ANA_HSIRKET = 'TK'
Yorumlar