How to select data from multiple tables which all have same id field?

Question

Let's suppose we have three tables student, teacher, parent in which sid present.

Answer 1

Okay if we have a table named Student and we want to select all the students in that table
The Query : Select * from Student
and if we have a table Teacher which is in relation with the table Student and we want to select the student name and his teacher name
The query : select student_name , teacher_name
From [Student] Join Teacher
On [Student].teacher_Id = teacher_Id

Answer 2

Then you need two Join operations in the same query to read from the 3 tables

You need to read and understand the JOIN notion

Answer 3

Also I want to select parent name as well from parent from 3 tables I have to pick

Answer 4

Okay