>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 separating the commands? First, get the top 10 records, then join the result with other tables.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)