compound SQL queries and DISTINCT problem

Hi folks,

I need to write compound queries like this:

select * from some_table1
minus
select * from some_table2

or:

select * from some_table1
intersect
select * from some_table2

The problem is, that I need all rows from some_table1 or some_table2 respectivly. However, the minus and intersect operator returns only distinct rows from the according tables. The SQL standard allows for example INTERSECT ALL. Oracle do not provide this feature. Does anyone have an idea to get all rows without using predicates in the where clause of the statements ?

Would appreciate any help.

Sten Received on Wed May 30 2001 - 05:52:52 CDT