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...