Join three tables(students names ,teachers names , class) and get their result ?

Answer 1

SELECT C.Name_EN AS Class_Name
, T.Name_EN AS Teacher_Name
, S.ID, S.Name_EN AS Student_Name
FROM students AS S, teachers AS T, class AS C
WHERE S.Class_ID=C.ID
AND T.Class_ID=T.ID

Answer 2

for example:

select * from students s, teachers t , class c
where c.id = s.class_id
and c.id = t.class_id

Answer 3

select* from students s,teachers t,class c where c.id=s.class_id and c.I'd=t.class_I'd and c.I'd=t.class_id