Hi All,
The below query is showing error. I am wondering where i did mistake.
Select a.as_of_dt,a.png_tm,rcvd,funds
from mfh..log_his a, (Select top 12 as_of_dt,max(png_tm)as png_tm,
from mf_holding..log_his
group by as_of_dt
order by as_of_dt desc)b
where a.as_of_dt = b.as_of_dt
and a.png_tm = b.png_tm
--------------------
Incorrect syntaxt near the keyword from
-------------------
Inputs are welcome !