SELECT
T1.ID ,
T1.PRO_TOTAL_AMT,
T1.CREATE_DATE_TIME
FROM
KPI_GOAL_PRO_INFO T1
WHERE
1=1
UNION ALL
(
SELECT
distinct T1.ID,
ifnull(
(
SELECT 1 FROM PM_CHILD_ANNUAL_EXPPLAN_INFO WHERE FISCAL_YEAR = T1.YEAR
)
, 0 )PRO_TOTAL_AMT,
T1.CREATE_DATE_TIME
FROM
PM_PROJECT_INFO T1
WHERE
1=1
SELECT
T1.ID ,
T1.PRO_TOTAL_AMT,
T1.CREATE_DATE_TIME
FROM
KPI_GOAL_PRO_INFO T1
WHERE
1=1
UNION ALL
(
SELECT
distinct T1.ID,
ifnull(
(
SELECT 1 FROM PM_CHILD_ANNUAL_EXPPLAN_INFO WHERE FISCAL_YEAR = T1.YEAR
)
, 0 )PRO_TOTAL_AMT,
T1.CREATE_DATE_TIME
FROM
PM_PROJECT_INFO T1
WHERE
1=1
这么滴尼