This is not working. It is telling me that From keyword not where expected.

select top 1

A.AUTH, COUNT(distinct P.PARID) as PARCEL_COUNT,A.USER1, A.NAME, D.DISTCODE, D.TOTALRATE, P.JUR

from RTAUTH A, RTDIST D,...