Re: Why is only one row returned

"Peter Shankey" <shankeyp_at_NOSPAM.comcast.net> wrote:

>why does the query:
>
>select a.value || b.value
>from (select value from v$parameter where name = 'log_archive_dest') a,
> (select value from v$parameter where name = 'log_archive_dest') b
>;
>
>return only one row? Even though a Comparison is not being used the query
>only returns one row.
>
>For N joined tables you need at least N-1 equijoin conditions in the where
>clause to avoid a Cartesian product.
>
>
>
You are not 'joining' the data sources. You are using in-line views to return independently return 1 value from each source ( even tho they are the same) and then concatenating the result..

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Mon Jun 02 2003 - 21:54:22 CEST