Select name_izd, (Select Top(1) name_book from First_table f_t Where f_t.id_izd=s_t.id Order by id_izd, count_pages desc) As [count_pages] from Second_table s_t