joining 3 tables

[saleemkhan]

i have 3 tables:-

1. student
   2.paper
   3.exam

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…

[m11]

I can help you but you have to try first.

[saleemkhan]

i need only mysql query…

[m11]

i need only mysql query…

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