SQL query on Oracle giving error

Question

SELECT A.PD_END_DT Recent_PD_END_DT,
       B.PD_END_DT Last_PD_END_DT,
       A.NRX_CNT - B.NRX_CNT DELTA
FROM   wkly_lnd.lnd_wkly_plan_rx_summary A,
       wkly_lnd.lnd_wkly_plan_rx_summary B 
WHERE  a.MKT_I D =b.MKT_ID;

Answer 1

you've got a space on the line

WHERE  a.MKT_I D =b.MKT_ID;

should it be:

WHERE  a.MKT_ID =b.MKT_ID;