create view s1_end_marksheet as select 
s.id,s.fname,s.lname,
eng.eng as eng,
math.math as math,
bio.bio as bio,
chem.chem as chem,
phy.phy as phy,
agric.agric as agric,
geo.geo as geo,
hist.hist as hist,
td.td as td,
pe.pe as pe,
hair.hair as hair,
elec.elec as elec,
bcp.bcp as bcp,
tail.tail as taiil,
art.art as art,
ent.ent as ent,
cre.cre as cre,
lug.lug as lug,
kisw.kisw as kisw,
lit.lit as lit,
ict.ict as ict
from s1_students s
left JOIN
s1_eng_end_marks eng on s.id= eng.id
left join s1_math_end_marks math on s.id=math.id
left join s1_bio_end_marks bio on s.id= bio.id
left join s1_chem_end_marks chem on s.id=chem.id
left join s1_phy_end_marks phy on s.id=phy.id
left join s1_agric_end_marks agric on s.id= agric.id
left join s1_geo_end_marks geo on s.id = geo.id
left join s1_hist_end_marks hist on s.id=hist.id
left join s1_td_end_marks td on s.id= td.id
left join s1_pe_end_marks pe on s.id = pe.id
left join s1_hair_end_marks hair on s.id=hair.id
left join s1_elec_end_marks elec on s.id=elec.id
left join s1_bcp_end_marks bcp on s.id=bcp.id
left join s1_tail_end_marks tail on s.id= tail.id
left join s1_art_end_marks art on s.id =art.id
left join s1_ent_end_marks ent on s.id = ent.id
left join s1_lug_end_marks lug on s.id= lug.id
left join s1_cre_end_marks  cre on s.id= cre.id
left join s1_kisw_end_marks kisw on s.id = kisw.id
left join s1_lit_end_marks lit on s.id=lit.id
left join s1_ict_end_marks ict on s.id =ict.id