现有三个表:
请看附件图
AttInfo ClassInfo UserInfo
下面实现的效果是显示记录attinfo相应的attid对应的classname ,现在又想关联attpub对应的userid,显示attid对应的username,请问如何实现,谢谢SELECT TOP 12 AttInfo.AttID, AttInfo.AttName, AttInfo.AttDate, ClassInfo.ClassID, ClassInfo.ClassName, AttInfo.AttClass,
AttInfo.AttPub
FROM AttInfo INNER JOIN
ClassInfo ON AttInfo.AttClass = ClassInfo.ClassID
ORDER BY AttInfo.AttDate DESC
请看附件图
AttInfo ClassInfo UserInfo
下面实现的效果是显示记录attinfo相应的attid对应的classname ,现在又想关联attpub对应的userid,显示attid对应的username,请问如何实现,谢谢SELECT TOP 12 AttInfo.AttID, AttInfo.AttName, AttInfo.AttDate, ClassInfo.ClassID, ClassInfo.ClassName, AttInfo.AttClass,
AttInfo.AttPub
FROM AttInfo INNER JOIN
ClassInfo ON AttInfo.AttClass = ClassInfo.ClassID
ORDER BY AttInfo.AttDate DESC
--try:SELECT TOP 12 AttInfo.AttID, AttInfo.AttName, AttInfo.AttDate, ClassInfo.ClassID,userid,username ClassInfo.ClassName, AttInfo.AttClass,
AttInfo.AttPub
FROM AttInfo INNER JOIN
ClassInfo ON AttInfo.AttClass = ClassInfo.ClassID
inner join UserInfo on AttInfo.AttID= UserInfo.userid
ORDER BY AttInfo.AttDate DESC
from AttInfo a
left join ClassInfo b on a... = b...
left join UserInfo c on a... = c....