look into the UNION or UNION ALL operators in the sql reference.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Andreas Tritt" <Andreas.Tritt_at_firemail.de> wrote in message
news:bg8ia6$ls38a$1_at_ID-19075.news.uni-berlin.de...
> 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 Tritt
>
>
>
Received on Wed Jul 30 2003 - 09:24:14 CDT
