SELECT
T.ID,
T.NAME,
T.CONTENT_ID,
T.MODIFTIED_TIME,
T.STATUS,
T.TERM_ID,
T.MODIFTIED_USER_ID
FROM TABLE1 T
WHERE 1 = 1
#if(null!=MODIFTIED_USER_ID)
AND T.MODIFTIED_USER_ID = #para(MODIFTIED_USER_ID)
#end
#if(null!=title)
AND T.NAME LIKE concat(concat('%',#para(title)),'%')
#end
UNION
SELECT
H.TERM_PK_ID AS ID,
H.NAME,
H.CONTENT_ID,
H.MODIFTIED_TIME,
H.STATUS,
H.TERM_ID,
H.MODIFTIED_USER_ID
FROM TABLE2 H
WHERE 1 = 1
#if(null!=MODIFTIED_USER_ID)
AND H.MODIFTIED_USER_ID = #para(MODIFTIED_USER_ID)
#end
#if(null!=title)
AND H.NAME LIKE concat(concat('%',#para(title)),'%')
#end我想用union查两张表,并且分页,JFinal在查总数的时候,拼接sql语句把union拼接上去了,就报ORA-01789: 查询块具有不正确的结果列数,这个怎么办?
项目:JFinal