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 -> SQL Help Needed

SQL Help Needed

From: Van Messner <vmessner_at_netaxis.com>
Date: Fri, 30 Oct 1998 18:29:12 -0500
Message-ID: <10s_1.2315$GZ6.6150@news14.ispnews.com>


HELP
 I have three small tables Request, Detail, Draft. Request provides a foreign key (column request) to Detail and to Draft. The queries below work fine but I want to combine the two result sets to pick up differences - i.e. the "1610" and "1310".
 I want one to end up with one result set (R1, S1, S2) or (R1, S1, R2, S2) whichever is easier. I've tried a lot of things with no success. How do I do this? It seems like this must be fairly basic but I'm missing something.  Many thanks

SELECT
  request.request R1,
  sum(draft.amount) S1
FROM
  request,
  draft
WHERE
  request.request=draft.request
GROUP BY
 request.request;
R1 S1
------- ----------

22828       110.25
23871         1610
25611         68.9
27148          150

SELECT
  request.request R2,
  sum(detail.quantity * detail.rate) S2 FROM
  request,
  detail
WHERE
  request.request = detail.request
GROUP BY
  request.request
R2 S2
------- ----------

22828       110.25
23871         1310
25611         68.9
27148          150


Received on Fri Oct 30 1998 - 17:29:12 CST

Original text of this message

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