Re: Multiple datasets in one dataset

On Tue, 16 Oct 2007 08:22:18 -0700, roman.morokutti_at_googlemail.com wrote:

>Hi Brian,
>
>***G*R*E*A*T***
>
>for the first look, the data seems to be ok. I have to verify it
>tomorrow.
>For now I have to catch the train.
>
>Your statement is fantastic. Many thanks. I also tried Outer Joins,
>but
>not the way you did. This offered me a whole new way to solve
>problems.
>
>I did something like
>
>where A.WP = B.WP(+)
>and A.Value_Group = 21 (+) Hui - Error
>
>and you did elegantly
>
>where B.WP(+) = A.WP
>and B.Value_Group(+) = 21 Superb
>
>Once again. Many thanks.
>
>Regards
>Roman
>
>P.S.:
>Tomorrow I will post again to state if the data has been selected
>right.

You're most welcome; i am glad to help. We were missing the assertions, which is why it was so hard to help from your first post.

The 21(+) will fail, because (+) is a COLUMN modifier, and 21 is a scalar value, not a COLUMN.

Let us know if it works for you.

B. Received on Tue Oct 16 2007 - 13:46:51 CDT