+ 2

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

13th May 2017, 2:41 AM
AlkhidierAbdalla Bakhiet idriss
AlkhidierAbdalla Bakhiet idriss - avatar
3 odpowiedzi
+ 2
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
23rd May 2017, 5:43 PM
Mohamed Abulnasr
Mohamed Abulnasr - avatar
0
for example: select * from students s, teachers t , class c where c.id = s.class_id and c.id = t.class_id
13th May 2017, 12:31 PM
Szabó Gábor
Szabó Gábor - avatar
0
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
29th Jun 2017, 5:07 AM
Kumar Rahul
Kumar Rahul - avatar