>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 >>
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.SsNumnot tested at all