Re: a beginner's question
From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Fri, 5 Dec 2008 08:23:46 -0800 (PST)
Message-ID: <e45601d5-d073-44c3-8819-b41f64f2aa5b@a12g2000yqm.googlegroups.com>
Date: Fri, 5 Dec 2008 08:23:46 -0800 (PST)
Message-ID: <e45601d5-d073-44c3-8819-b41f64f2aa5b@a12g2000yqm.googlegroups.com>
On Dec 4, 8:17 pm, Geoff Muldoon <geoff.muld..._at_trap.gmail.com> wrote:
> Denny says...
>
> > I have two tables contaning 4 rows above.
> > And I'd like to show the result below.
> > How to make SQL query to do that?
> > Plz let me know?
>
> Read the fine manual (or google) on UNION (or maybe UNION ALL depending on
> your needs).
>
> GM
The mention 'fine' manual can be found here http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries004.htm#i2054381
Topic: The UNION [ALL], INTERSECT, MINUS Operators
HTH -- Mark D Powell -- Received on Fri Dec 05 2008 - 10:23:46 CST