一个有关left join 的sql语句查询

[bnututu]

有四张表，student,classroom,testplace,school
其中，student.roomid与classroom.id相关联，
classroom.testplaceid与testplace.id相关联，
testplace.schoolid与school.id相关联。
classroom表有name字段（考场），school表有name字段（学校），
但testplace表没有name字段，是通过链接school而得到
school的name字段来作为相应的考点字段

因为链接老出错，有重复纪录，用了distinct也不行。
求救求救

[black_snail]

select * from student , classroom , testplace , school
where student.roomid = classroom.id
and classroom.testplaceid = testplace.id
and testplace.schoolid = school.id

[CrazyFor]

select a.*,b.*,c.*,d.* from student a, classroom b, testplace c, school d
where student.roomid = classroom.id
and classroom.testplaceid = testplace.id
and testplace.schoolid = school.id

[jampei]

slect 你要的字段
from student join classroom on student.roomid = classroom.id
join testplace on classroom.testplaceid = testplace.id
join school on testplace.schoolid = school.id

[Robin]

因为你用的是lefe join 的缘故！
要用内连接吧！
如楼上的！