Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP! Oracle Won't Let Me Outer Join...
"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 Received on Mon Apr 08 2002 - 17:36:59 CDT