>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