Hi Naomi,
Thanks for your reply.
I noticed you have 2 selects after the INNER JOIN, so I removed 1 and get a T1 Alias not found error.
Maybe the inner join not quite right.
Regards
Doug Johnston
>>Hi,
>>
>>I have a VFP table with the following structure...
>>
>>idnum
>>keyword
>>cgroup
>>iscore
>>
>>...I have one SQL statement that gets the top 20 percent (iscore) of all records (100 records returns 20), and this works fine...
>>
>>SELECT TOP 20 PERCENT,* FROM Table ORDER BY iscore
>>
>>I am now trying to get the top 20 percent (iscore) of each group (cgroup) and am struggling for the correct SQL syntax.
>>
>>Regards
>>Doug Johnston
>
>Doug,
>
>Please try, not tested:
>
>select T1.* from Table T1 inner join ;
>(select SELECT TOP 20 PERCENT PK ;
>FROM Table ORDER BY iScore where cGroup = T1.cGroup) S1 on T1.PK = S1.PK