ORA 00905 Missing keyword
723101Sep 17 2009 — edited Apr 1 2013when 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