有3个表
第一个表里sutdent(id name classid)
第二个表class(classid classname) (classid一共五位,是depid+2位数 例如55501)
第三个表department(depid,money)(这里的depid是三位数 例如555)
我想查询出student给定的ID值查询出来 name 和classname和money的 值。请高手帮忙。我对数据库太过敏了
谢谢。
第一个表里sutdent(id name classid)
第二个表class(classid classname) (classid一共五位,是depid+2位数 例如55501)
第三个表department(depid,money)(这里的depid是三位数 例如555)
我想查询出student给定的ID值查询出来 name 和classname和money的 值。请高手帮忙。我对数据库太过敏了
谢谢。
FROM student AS A
JOIN class AS B
ON A.classid=B.classid
JOIN department AS C
ON LEFT(B.classid,3)=C.deptid;
inner JOIN class AS B ON A.classid=B.classid
inner JOIN department AS C ON LEFT(B.classid,3)=C.deptid;
a.[name],
b.[classname],
c.[money]
from
[student] a,
[class] b,
[department] c
where
a.classid=b.classid
and
c.depid=left(classid,3)
SELECT A.name,B.classname,C.money FROM student AS A
JOIN class AS B ON A.classid=B.classid
JOIN department AS C ON LEFT(B.classid,3)=C.deptid;