MSSQL çözemediğim sorgu

 
  rs = SELECT * FROM tblkat ORDER BY katsira DESC 
   
  while (rs.read) 
  { 
      rs2 = SELECT TOP 1 * FROM tblurun WHERE urunkat = [b]rs["katid"][/b] ORDER BY urunsira DESC 
  } 
  

 
  SELECT tblkat.katid, tblkat.katadi, tblkat.katsira,  
              MAX(tblurun.urunid), tblurun.urunkat, MAX(tblurun.urunsira) 
  FROM tblurun, tblkat 
  WHERE tblkat.katsira = tblurun.urunkat 
  GROUP BY  tblkat.katid 
  ORDER BY tblkat.katsira desc;