Looks like there is no relation between the tables in your query. Also, where does Month come from? I would expect a sql statement more like this.
select pid,
case when (pamount<=frrresult)
then '!'
else NULL
end as notification
from pd, fr
where pd.pid = fr.pid
and MONTH(fr.Month) = MONTH(GETDATE())
Good luck!