SELECT

AA.tb_id AS tb_id,

AA.tb_name AS tb_name,

AA.tb_level AS tb_level,

AA.tb_parent_id AS tb_parent_id,

AA.tb_alias AS tb_alias,

AA.pop3_id AS pop3_id,

AA.last_route AS last_route,

AA.flag_use AS flag_use,

AA.flag_tbtype AS flag_tbtype,

AA.tbclass_1,

AA.tbclass_2,

AA.tbclass_3,

AA.register_date AS register_date,

AA.cnt_agent AS cnt_agent,

BB.cnt_option AS cnt_option,

CC.cnt_subtb AS cnt_subtb,

DD.cnt_templet AS cnt_templet

FROM

v_tblistall1 AS AA,

v_tblistall2 AS BB,

v_tblistall3 AS CC,

v_tblistall4 AS DD

WHERE

AA.tb_id = BB.tb_id AND

AA.tb_id = CC.tb_id AND

AA.tb_id = DD.tb_id

ORDER BY

AA.tb_level, AA.sort_order

이 쿼리를 날렸을때 아래와 같은 에러가뜨네요..

SQLException caught subSelectTBListWithQuery: The current query would generate a key size of 660 for a work table.

This exceeds the maximum allowable limit of 600

여기서 v_tblistall1, v_tblistall2, v_tblistall3, v_tblistall4 는 view입니다.

sybase에서 from절에는 subQuery가 지원이 안된다구 해서 view로 만들어서 쿼리를 실행했는데 에러가 나네용.. 흑흑.. 왜 나는지 좀 알려주세요..

해결책도 함께.. ^^