distinct in union

#1

The following query:
select a_id,b, c from table1
union all
select a2_id,b2,c2 from table2

gives me a result:

1,2,3
2,2,3

but I want only values from second table. What is the most efficient
way to do that?

#2

On Oct 6, 10:45*am, Micha³ Jab³oñski <michal.jablo... (AT) gmail (DOT) com>
wrote:

Quote:

The following query:
select a_id,b, c from table1
union all
select a2_id,b2,c2 from table2

gives me a result:

1,2,3
2,2,3

but I want only values from second table. What is the most efficient
way to do that?

Query the second table ONLY?

WTF!

Cheers.

Carlos.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

distinct in union

comp.databases.oracle.server comp.databases.oracle.server

distinct in union - 10-06-2010 , 03:45 AM

Re: distinct in union - 10-06-2010 , 04:10 AM