如何在超过3个表上编写内部连接的选择查询

问题描述

以下是我的查询，但没有显示任何结果。请帮帮我。

Following is my query which is not displaying any result. Please help me out.

select * from tblPersonalDetails Inner Join tblFamilyDetails on tblPersonalDetails.Email=tblFamilyDetails.Email
Inner Join tblImageDetails on tblPersonalDetails.Email=tblImageDetails.Email
Inner Join tblEducationalDetails on tblPersonalDetails.Email=tblEducationalDetails.Email
Inner Join tblAcademicDetails on tblPersonalDetails.Email=tblAcademicDetails.Email
Inner Join tblWorkExpDetails on tblPersonalDetails.Email=tblWorkExpDetails.Email
Inner Join tblReferenceDetails on tblPersonalDetails.Email=tblReferenceDetails.Email
Inner Join tblDeclarationDetails on tblPersonalDetails.Email=tblDeclarationDetails.Email where (tblPersonalDetails.FirstName like '%' + @search + '%' )

推荐答案

这篇关于如何在超过3个表上编写内部连接的选择查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！