Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> append views
I´ve go a problem under oracle 8.1
we have written two views
1)
create view vw141 as
select
kuno as kuno
matno as matno
YYYYMM as YYYYMM
amount as amout
from tab141
DATA
kuno matno YYYYMM amount
01 a 200301 47 02 b 200302 1
2)
create view vw142 as
select
kuno as kuno
matno as matno
YYYYMM as YYYYMM
amount as amout
from tab142
DATA
kuno matno YYYYMM amount
10 x 200301 2 12 y 200302 4
now we need to append these two views to get all Data in one view to get the following result:
DATA
kuno matno YYYYMM amount
01 a 200301 47 02 b 200302 1 10 x 200301 2 12 y 200302 4
Can someone Help please.
-- Mit freundlichen Grüßen Andreas TrittReceived on Wed Jul 30 2003 - 08:47:22 CDT