Looking at it, it looks like a possiblity. Let me try it.

Thanks


>>I don't know if this is doable.
>>
>>

>>SELECT TOP 10 demo.idcard, hra.hraid, hraspec.hracomplet ;
>>	FROM demo d, hra h1, hraspec h2 ;
>>	WHERE d.ssnum = h1.ssnum ;
>>		AND h1.hraid = h2.hraid ORDER BY 1
>>

>>
>>I want to extract first to 10 rolls from demo and their related records from hra and hraspec. I can't get it to work.
>>
>>What am I doing wrong.
>>
>>Thanks
>
>How about:
>

>SELECT D1.IdCard,;
>       D2.*;
>FROM (SELECT TOP 10 IdCard, SsNum FROM Demo ORDER BY IdCard) D1;
>INNER JOIN (SELECT h1.SsNum, h1.hraid, h2.hracomplet
>                   FROM hra h1
>            INNER JOIN hraspec h2 ON h1.hraid = h2.hraid) D2;
>ON D1.SsNum = D2.SsNum
>

>not tested at all