create view s1_marksheet2 AS 
SELECT s.id,s.fname,s.lname,
art.art AS art,
agric.agric AS agric,
bio.biology as bio,
chem.chemistry as chem,
phy.physics as phy,
hist.history as history,
math.math as math,
eng.english as eng,
geography.geography AS geography,
lug.lug as lug,
lit.lit as lit,
kisw.kisw as kisw,
cre.cre as cre,
td.td as td,
ict.ict as ict,
ent.ent as ent,
pe.pe as pe,
bcp.bcp as bcp,
hair.hair as hair,
elec.elec as elec,
tail.tail as tail
FROM
s1_students s 
left JOIN
s1_art_marks art on s.id= art.id
left join
existing_s1_agric_marks agric on s.id =agric.id
left join
s1_geo_marks geography on s.id =geography.id
left JOIN
s1_bio_marks biology on s.id= biology.id
left JOIN
s1_chem_marks chemistry on s.id=chemistry.id
left JOIN
s1_phy_marks physics on s.id= physics.id
left JOIN
s1_hist_marks history on s.id = history.id 
left JOIN
s1_math_marks math on s.id= math.id 
left JOIN
s1_eng_marks english on s.id= english.id
left join 
s1_lug_marks lug on s.id = lug.id 
left join 
s1_lit_marks lit on s.id= lit.id 
LEFT JOIN
s1_kisw_marks kisw on s.id=kisw.id
left join 
s1_cre_marks cre on s.id= cre.id
left JOIN
s1_td_marks td on s.id = td.id
left JOIN 
s1_ict_marks ict on s.id = ict.id
left JOIN 
s1_ent_marks ent on s.id= ent.id
left JOIN
s1_pe_marks pe on s.id =pe.id
left join 
s1_bcp_marks bcp on s.id=bcp.id
left join 
s1_hair_marks hair on s.id =hair.id
left join
s1_elec_marks elec on s.id= elec.id
left join 
s1_tail_marks tail on s.id= tail.id