"contrapositive" <contrapositive_at_hotmail.com> wrote in message news:<3cb21fd1_1_at_nopics.sjc>...
> "Mark D Powell" <mark.powell_at_eds.com> wrote in message
> news:178d2795.0204080917.6d78622b_at_posting.google.com...
> [...]
> > JK, if the order number is carried in the order_details table then
> > substitute d.order_number for h.order_number. Being that you do not
> > show the join of the headers to details this is probably a partial
> > query. It would probably be better to include all join conditions in
> > the where clause to get the best possible response.
> >
> Thanks Mark, but if I posted the entire query, chances are no one would want
> to look at it. I don't think it would offer much more to work with anyway
> (and for security reasons, I can't post blocks of code to a public forum
> without changing names and "watering it down"). I do see your point, though.
> Unfortunately order number is only carried at the header level (an
> "ORDER_ID" provides the link).
>
> -jk
I would like to test this before I open my mouth, but being pressed
for time have you tried performing the concatenation in an inline view
and then outer joining the inline view to the target?
Received on Tue Apr 09 2002 - 12:38:37 CDT
