Re: Interesting Distributed UNION Question

"Roger Corman" <rogcorpr_at_hotmail.com> wrote in message news:f8285955.0410280611.2e6b8e48_at_posting.google.com...
> > This smacks of homework. Apologies if it isn't, but here's a hint if it
is
> > (or question to be answered if it isn't)...
> >
> > Why do you need the SOURCE column?
>
> Looks like I need to provide some more detail. It was a good laugh to
> read the "smacks of homework" line this morning. I wasn't sure if I
> was to be congratulated or offended by the remark! It is true that it
> smacks of University drivel. Anyway...
>
> The Oracle server version is 9i. The SQL Server version is 2000. I
> am somewhat new to the Oracle programming world with years of SQL
> Server experience.
>
> The SOURCE column would not be needed. The intent of the question was
> to keep things as simple as possible.
>

Well, if the SOURCE column isn't needed, leave it out and your problem is solved. A UNION eliminates all redundant rows, so you will only retrive results from either A or B, never from both. Received on Thu Oct 28 2004 - 09:38:45 CDT