您不能在条件中使用别名（查询的一部分）
试试这个：
SELECt donem, bolge_adi, sehir_tasra "1=艦, 2=T", COUNT(DISTINCT mekankodu) "M.SAYISI", SUM(b2b_dagitim + b2b_transfer - b2b_iade) satisFROM mps_view2WHERe donem IN ('200612','200712','200812','200912') AND (ob IS NOT NULL OR b2b_ob IS NOT NULL)GROUP BY donem, bolge_adi, sehir_tasraHAVINg SUM(b2b_dagitim + b2b_transfer - b2b_iade) > 0ORDER BY donem, bolge_adi, sehir_tasra
