Re: two tables, one result set, but no join!

andrewst_at_onetel.com wrote:

>> >Use UNION.

>> Wouldn't UNION ALL be better in case there are duplicates?

>What would be the point of having duplicates?
>What would be the point of having duplicates?

Getting all the data?
Getting all the data?

The OP presumably wants to process it in some way, and may need duplicates, since the data is coming from two separate tables.

Why have UNION ALL at all?
Why have UNION ALL at all?

Paul...

-- 

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2, 

Oracle, 9.2.0.1.0 (Enterprise Ed.)
Interbase 6.0.2.0;

When asking database related questions, please give other posters 
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.
 
Furthermore, As a courtesy to those who spend 
time analyzing and attempting to help, please 
do not top post.