SQL语句为什么有错误?!!高分求救!!!1
PreparedStatement catHierarchy=conn.prepareStatement("WITH RecCatList(LEVEL,cat_id,par_cat_id,name,description) AS ("+
" select 1,ROOT.cat_id,ROOT.par_cat_id,ROOT.name,ROOT.description FROM category ROOT where ROOT.cat_id=? UNION ALL"+
" select PARENT.LEVEL+1,CHILD.cat_id,CHILD.par_cat_id,CHILD.name,CHILD.description from RecCatList PARENT,category CHILD"+
" where PARENT.cat_id=CHILD.par_cat_id and PARENT.LEVEL>?)"+
" select LEVEL,cat_id,par_cat_id,name,description from RecCatList");