>>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.
Yes. I know.
I thought there is a way to do it in one step.
thank tho.
The American Republic will endure, until politicians realize they can bribe the people with their own money.
- Alexis de Tocqueville
No man’s life, liberty, or property is safe while the legislature is in session.
– Mark Twain (1866)