select tbl.id, st.studname,tbl.subject

from Student st

join

(

select id, 'maths' as subject from Marklist where maths= (select max(maths) from Marklist )

union

select id, 'physics' as subject from Marklist where physics = (select max(physics) from Marklist )

union

select id, 'English' as subject from Marklist where English = (select max(English) from Marklist )

)

tbl

on st.id = tbl.id