Sql-server 2005中的内部联接问题
|
Select FileUpload.FileName AS FINAME, FileUpload.FilePath,MemberPersonalInformation.FirstName As SharedBy from FileUpload
INNER JOIN
ContentManagement ON ContentManagement.FileId=FileUpload.FileId
INNER JOIN
MemberPersonalInformation ON MemberPersonalInformation.MemberId=ContentManagement.CreatedBy
INNER JOIN
SubjectMaster ON ContentToIndividual.SubjectId=SubjectMaster.SubjectId
where
FileUpload.FileId in
(Select FileId from ContentManagement where ContentId in
(Select ContentId from ContentToIndividual where ShowToMemberId=12)
AND ContentManagement.ContentTypeId=1 and ContentManagement.SessionId=4)
没有找到相关结果
已邀请:
2 个回复
死狸蔽垂藐
表连接到先前未引用的表。 您需要先加入才能在Join中引用它。 例如Select FileUpload.FileName AS FINAME, FileUpload.FilePath,MemberPersonalInformation.FirstName As SharedBy from FileUpload INNER JOIN ContentManagement ON ContentManagement.FileId=FileUpload.FileId INNER JOIN MemberPersonalInformation ON MemberPersonalInformation.MemberId=ContentManagement.CreatedBy -- You need to add it in here Inner Join ContentToIndividual on SomeColumn = AnotherColumn INNER JOIN SubjectMaster ON ContentToIndividual.SubjectId=SubjectMaster.SubjectId where FileUpload.FileId in (Select FileId from ContentManagement where ContentId in (Select ContentId from ContentToIndividual where ShowToMemberId=12) AND ContentManagement.ContentTypeId=1 and ContentManagement.SessionId=4)贡炮逗握惫
或联接，因为您没有从任何一个表中选择任何列-请记住，子查询与主查询是分开的;您仅使用它来获取FileId列表。也有可能优化语句的其余部分。Select FileUpload.FileName AS FINAME, FileUpload.FilePath,MemberPersonalInformation.FirstName As SharedBy from FileUpload INNER JOIN ContentManagement ON ContentManagement.FileId=FileUpload.FileId INNER JOIN MemberPersonalInformation ON MemberPersonalInformation.MemberId=ContentManagement.CreatedBy where FileUpload.FileId in (Select FileId from ContentManagement where ContentId in (Select ContentId from ContentToIndividual where ShowToMemberId=12) AND ContentManagement.ContentTypeId=1 and ContentManagement.SessionId=4)SELECT FileUpload.FileName AS FINAME, FileUpload.FilePath,MemberPersonalInformation.FirstName As SharedBy FROM FileUpload INNER JOIN ContentManagement ON ContentManagement.FileId=FileUpload.FileId AND ContentManagement.ContentTypeId=1 AND ContentManagement.SessionId=4 INNER JOIN ContentToIndividual ON ContentToIndividual.ContentId = ContentManagement.ContentId -- Iguessed at this join AND ContentToIndividual.ShowToMemberId=12 INNER JOIN MemberPersonalInformation ON MemberPersonalInformation.MemberId = ContentManagement.CreatedBy