Question

求三表联合查询的SQL查询语句

table1中id,name,table2_id;
table2中id,name;
table3中id,name,table2_id;
三表是互相关联的，要查所有字段并且排序请问这个语句怎么写？
上面写错了，是下面的
table1中id,name,table2_id,table3_id;
table2中id,name;
table3中id,name,table2_id;

Answer 1

多表联结查询—三表联结

SELECT
S.SName AS 姓名, CS.CourseName AS 课程, C.Score AS 成绩
FROM Students AS S
INNER JOIN Score AS C ON (S.SCode = C.StudentID)
INNER JOIN Course AS CS ON (CS.CourseID = C.CourseID

Answer 2

select a.id,a.name,b.id,b.name,c.id,c.name from a,b,c
where a.b_id=b.id and a.c_id = c.id and b.id=c.b_id

Answer 3

select * from table1 A, table2 B, table3 C
WHERE
A.table2_id=B.id
and A.table3_id=C.id
ORDER BY id ,name ;
如果不通过请留言！

Answer 4