Re: Multiple datasets in one dataset

On Thu, 18 Oct 2007 07:53:02 -0700, roman.morokutti_at_googlemail.com wrote:

>> Could those records bve ignored? If so, use a WHERE clause to exclude
>> such a case, such as, AND A.Value1 > 0 AND A.Value2 > 0 ... AND
>> A.Value10 > 0.
>
>This should be discussed. But I think they should be shown also.

For the time being, perhaps you can try them to see if there is a difference.

>> (+) is Oracle specific, just like *= is SQL Server specific. All
>> support the ANSI syntax, however.
>
>I was aware of this, but to lazy to convert the statement into
>standard SQL ;-(

I don't like the SQL standard syntax for JOINs. So, you'll get no argument from me. :)

>> An EXPLAIN PLAN would probably be helpful here as well.
>
>Here it is:

<SNIP>

Looks fine to me. I do not know what the problem is. Perhaps someone else can help.

B. Received on Thu Oct 18 2007 - 10:19:10 CDT