with t1 as (
-- 第一个查询
),
t2 as (
-- 第二个查询
),
t3 as (
-- 第三个查询
),
.........
select t1.ID, t1.num - t2.num + t3.num from t1,t2,t3 where t1.ID = t2.ID and t1.ID = T3.ID
with t1 as (
-- 第一个查询
),
t2 as (
-- 第二个查询
),
t3 as (
-- 第三个查询
),
.........
select t1.ID, t1.num - t2.num + t3.num from t1,t2,t3 where t1.ID = t2.ID and t1.ID = T3.ID