Re: Basic(?) SQL question -- set operations on >1 result set ???

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Fri, 06 Jun 2003 06:11:20 +0200
Message-ID: <e050ev4fttv7c8d0s6ph1md3pfdanutjnp@4ax.com>

On Thu, 05 Jun 2003 16:29:21 -0600, Rithban <rithban_at_yahoo.com> wrote:

>Is it possible to merge separate result sets into a single query, or am I
>going to have to jump through hoops?

No, you just have to under stand the SQL syntax <query1>
UNION|INTERSECT|MINUS
<query2>
UNION|INTERSECT|MINUS
<query3>

and evidently, because you are using set operations the result will always be distinct

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jun 05 2003 - 23:11:20 CDT