Re: Why is only one row returned

I will have to set that situation up and try it. FYI each of inline views in my example will only return one row.

"Xingshan He" <xingshan_he_at_hotmail.com> wrote in message news:37e4d47.0306021403.64b19dff_at_posting.google.com...
> 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:18:19 CEST