Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL - View with two tables?

Re: SQL - View with two tables?

From: osy45 <member18536_at_dbforums.com>
Date: Wed, 28 May 2003 07:21:05 +0000
Message-ID: <2929991.1054106465@dbforums.com>

create or replace view bla ( columnlist) AS select columnlist from table1
union
select coumnlist from table2

--
Posted via http://dbforums.com

Received on Wed May 28 2003 - 02:21:05 CDT

This message: [ Message body ]
Next message: porschberg: "16Bit character set question"
Previous message: Anthony Hogan: "Re: SQL - View with two tables?"
In reply to: Xaver Trapichler: "SQL - View with two tables?"
Next in thread: Xaver Trapichler: "Re: SQL - View with two tables?"
Reply: Xaver Trapichler: "Re: SQL - View with two tables?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US