T1与T2表结构相同，t1与t2表中都有dividend_low, dividend_middle, dividend_high三个字段，但是存储的数据各不相同，现在我想获得T1与T2中这几个字段的值分为六列显示出来，希望各位高手帮忙，解决一下。小弟在此多谢了！
以下是我从T1表中获得数据的SQL：
SELECT b.period_value, c.pay_period_value, trim(sex), smoke_flag, age, policy_age, dividend_low, dividend_middle, dividend_high
FROM T1 a, period_define b, pay_period_define c
WHERE plan_id='00410801' and a.plan_period_id = b.period_id(+) and a.pay_period_id = c.pay_period_id(+)
ORDER BY b.period_value, c.pay_period_value, trim(a.sex), smoke_flag, age, policy_age
下面是从T2表中获得所需数据的SQL：
SELECT b.period_value, c.pay_period_value, trim(sex), smoke_flag, age, policy_age, dividend_low, dividend_middle, dividend_high
FROM T2 a, period_define b, pay_period_define c
WHERE plan_id='00410801' and a.plan_period_id = b.period_id(+) and a.pay_period_id = c.pay_period_id(+)
ORDER BY b.period_value, c.pay_period_value, trim(a.sex), smoke_flag, age, policy_age
如何将他们整合呢？
|
