56,677
社区成员
发帖
与我相关
我的任务
分享
SELECT
*
FROM
(
SELECT
PO_PUBLICOPINION.SYSID,
PO_PUBLICOPINION.OPINION_ID,
GSD_AREA,
(
SELECT
group_concat(FULLNAME)
FROM
SYS_APP_REGION
WHERE
InOperat (
REGIONCODE,
PO_PUBLICOPINION.GSD_AREA
)>0
) AS NBDCV$GSD_AREA ,
PO_PUBLICOPINION.REPRINTCOUNT
FROM
PO_PUBLICOPINION
) BASETABLE
SELECT
*
FROM
(
SELECT
PO_PUBLICOPINION.SYSID,
PO_PUBLICOPINION.OPINION_ID,
GSD_AREA,
(
SELECT
group_concat(FULLNAME)
FROM
SYS_APP_REGION
WHERE
FIND_IN_SET(regioncode,po_publicopinion.gsd_area)>0
) AS NBDCV$GSD_AREA ,
PO_PUBLICOPINION.REPRINTCOUNT
FROM
PO_PUBLICOPINION
) BASETABLE
BEGIN
declare idx int(10);
set idx = FIND_IN_SET(v_substr,v_parentstr);
return idx;
end;