Re: Why is only one row returned

It will return only one row if both views only have 1 row in them.

Run the queries seperately for your inline views and see how many rows get returned.

"Peter Shankey" <shankeyp_at_NOSPAM.comcast.net> wrote in message news:<b-qdnT2wCdzDBUajXTWcoA_at_comcast.com>...
> 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_format') 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.
Received on Tue Jun 03 2003 - 00:03:43 CEST