我的实例: SELECT CASE t1.type WHEN 1 THEN sum( t2.remain_quantity ) WHEN 0 THEN sum( t2.quantity ) END AS sum FROM tn_grms_stock_record t1, tn_grms_stock_record_item t2 WHERE t1.batch_no = 'R202302150003' and t2.batch_no = 'R202302150003'