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_OUTSTANDIN
G.AMT_REQU
ESTED) Total
FROM OUTSTANDING
GROUP BY CLAIM_NUMBER
HAVING CLAIM_NUMBER='123'
Start Free Trial
