Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Unions With Grouping Group Values

Re: Unions With Grouping Group Values

From: Tim Marshall <TIMMY!_at_PurplePandaChasers.Moertherium>
Date: Mon, 19 Sep 2005 10:40:27 -0230
Message-ID: <dgmdc2$ulm$1@coranto.ucs.mun.ca>


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!!" - Me
Received on Mon Sep 19 2005 - 08:10:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US