[thelist] Problem with SQL Intersect query

Joel Lieberman joel_lieberman at yahoo.com
Sun Jan 6 09:01:59 CST 2002

Greetings -

I wonder if someone can help with a problem that I
have with Oracle intersect queries.  It seems that
when I compose a multi-clause query with a union
condition, then no matter how many unions are
involved, the record set returns with expected

When I substitute the intersection clause, then the
returned results are only consistent with a single

So if the table has authors and I ask for all records
where author is "A" union all records where author is
"B" etc, I get the correct records.

With intersect used as a subsetting condition
(exclusion) they cannot be composed with more than a
single intersection.



Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!

More information about the thelist mailing list