Advertisement

07.10.2007 at 12:31PM PDT, ID: 22686924
[x]
Attachment Details

Oracle 8i select column question

Asked by michael1174 in Oracle 8.x, Oracle Database

Tags: , , ,

I have a query that returns everything fine, but when I join a table to that query, the new table's column I need to sum gets duplicated, thus throwing off the total.  Is there anyway to seperate that new table own its own as a column, and then join it to the underlying tables?

I am using oracle 8i.  The new table select would look something like this:

SELECT CLAIM_NUMBER,
Sum(MIGRATE_GRE_OUTSTANDING.AMT_REQUESTED) Total
FROM OUTSTANDING
GROUP BY CLAIM_NUMBER
HAVING CLAIM_NUMBER='123'

Start Free Trial
[+][-]07.10.2007 at 12:52PM PDT, ID: 19457134

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.10.2007 at 01:18PM PDT, ID: 19457361

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.11.2007 at 05:43AM PDT, ID: 19462010

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.11.2007 at 07:17AM PDT, ID: 19462826

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.11.2007 at 07:20AM PDT, ID: 19462850

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Oracle 8.x, Oracle Database
Tags: oracle, 8i, select, column
Sign Up Now!
Solution Provided By: sujit_kumar
Participating Experts: 2
Solution Grade: A
 
 
[+][-]07.11.2007 at 08:09AM PDT, ID: 19463354

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32