Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Unions With Grouping Group Values
Jaap W. van Dijk wrote:
> You've got two subquery's, each producing one record per building/year
> combination. Use them as inline views and join them, something like
> this:
<snip>
> If not all building/year combinations of labor are present in other
> and/or vice versa, use some form of outer join.
Thank you Jaap.
-- Tim http://www.ucs.mun.ca/~tmarshal/ ^o< /#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake /^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - MeReceived on Mon Sep 19 2005 - 08:10:27 CDT