Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: append views
Thanks
it is working.
-- Mit freundlichen Grüßen Andreas Tritt Optimal Process Consultants Otto-Hahn-Straße 21 85435 Erding Tel:08122 - 840 61 "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> schrieb im Newsbeitrag news:3f27d50d$0$18486$ed9e5944_at_reading.news.pipex.net...Received on Wed Jul 30 2003 - 10:40:21 CDT
> 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
> >
> >
> >
>
>