RenitlahHelp
asked on
Oracle SQL Question
I am receiving an invalid identifier for "CUSTBAL"... any ideas why? Thanks!
SELECT CUSTOMER_NUM, CUSTOMER_NAME, SUM(BALANCE) AS CUSTBAL, REP.REP_NUM FROM CUSTOMER, REP WHERE CUSTOMER.REP_NUM=REP.REP_NUM AND (CUSTBAL>10000) GROUP BY CUSTOMER_NUM;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent!
select CUSTOMER_NUM, CUSTOMER_NAME, CUSTBAL, REP.REP_NUM from (
SELECT CUSTOMER_NUM, CUSTOMER_NAME, SUM(BALANCE) AS CUSTBAL, REP.REP_NUM FROM CUSTOMER, REP
WHERE CUSTOMER.REP_NUM=REP.REP_N
as tblderived where (CUSTBAL>10000)