Sql Query Using Joins

Sql Query Using Joins

I have 2 tables - student, exam
Student Table Schema:
id Name Course
1 Kavi Dr.
2 Priya Engg.
Exam Table Schema:
Examid Student_id Exam Date
1 1 22-03-2014
2 2 23-04-2014
My requirement is, i need to join these 2 tables,so that i can access all
columns in that table. So far i have tried Query using Innerjoin but i get
the result to be as
id Name Course
1 Kavi Dr.
2 Priya Engg.
1 1 22-03-2014
2 2 23-04-2014
But I need it like ,
id Name Course Exam Date
1 Kavi Dr. 22-03-2014
2 Priya Engg. 23-04-2014
Pls Help!