Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA 00905 Missing keyword

723101Sep 17 2009 — edited Apr 1 2013
when i try to execute the following query in oracle SQL developer it throws me an error message

ORA 00905 Missing keyword

Vendor Code 905Error at Line:27 Column:2

SELECT
A.agent_no,
a.agent_name,
p.policy_no,
D.driver_no,
d.mvr_predict_score,
d.mvr_received,
COUNT(p.policy_NO) AS total_no_overrides,
MAX(dividend.Cnt) / MAX(divisor.Cnt) AS "TOTAL% OF U/B"
FROM driver D
INNER JOIN policy p
ON p.fullkey = d.fullkey
INNER JOIN agent A
ON p.agent_no = a.agent_no
INNER JOIN(
SELECT
p.policy_no,p.agent_no,COUNT(p.policy_no) AS cnt
FROM
driver D,
policy p,
agent A
WHERE
D.request_mvr = 'U'
AND p.fullkey = d.fullkey
AND p.agent_no = a.agent_no
GROUP BY p.policy_no,p.agent_no
) AS Dividend
ON p.fullkey = Dividend.FullKey
AND p.agent_no = Dividend.agent_no
INNER JOIN(
SELECT
p.policy_no,p.agent_no,COUNT(p.policy_no) AS cnt
FROM
driver D,
policy p,
agent A
WHERE p.fullkey = d.fullkey AND p.agent_no = a.agent_no
GROUP BY p.policy_no,p.agent_no
) AS Divisor
ON p.fullkey = Divisor.FullKey
AND p.agent_no = Divisor.agent_no
WHERE
D.request_mvr = 'U'
GROUP BY
a.agent_no,
agent_name,
p.policy_no,
D.driver_no,
D.mvr_predict_score,
d.mvr_received

Any help is really appreciated
thanks,
karthik
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 29 2013
Added on Sep 17 2009
5 comments
39,513 views