joining 3 tables

i have 3 tables:-

  1. student

student fields are
id , name

paper fields are
id, paper, max_marks

exam fields are
id, student_id,paper_id, marks obtained

i need final table
paper marks_obtained max_marks
abc xyz xyz
bdb jdud jjd
sum xndd jddg
plz give me sql code for this table…

I can help you but you have to try first.

i need only mysql query…

And if you try first I will give you that query.

Sponsor our Newsletter | Privacy Policy | Terms of Service