sysbase问题,很急,请高手帮忙
存储过程p_jz_rj_2
select a.jbh,a.jm,b.hp_id,b.hpmc,b.hpgg,b.hpxh,sum(b.je) from t_planmove_main a,t_rk_jd_sub b
where a.jdrk_bh=b.jdrk_bh
group by a.jbh,a.jm,b.hp_id,b.hpmc,b.hpgg,b.hpxh
在执行存储过程时报以下错误:
Error: Number (414) Severity (16) State (1) Procedure (p_jz_rj_2) The current query would generate a key size of 749 for a work table. This exceeds the maximum allowable limit of 600. , Batch 1 Line 20
而单独执行select ,则没错