大家帮忙看看这个联合查询怎么查不出数据

Question

SELECT     tblUserBaseInfo.Email, tblUserBaseInfo.Nick, tblUserBaseInfo.Name, tblUserEducationInfo.SchoolName, tblUserEmploymentInfo.DepartmentID, 
tblUserEmploymentInfo.CompanyName
FROM         tblUserBaseInfo 
INNER JOIN tblUserEducationInfo ON tblUserBaseInfo.ID = tblUserEducationInfo.ID 
INNER JOIN tblUserEmploymentInfo ON tblUserBaseInfo.ID = tblUserEmploymentInfo.ID三个表的主键都是ID

Answer 1

------三个表里都有数据么？SELECT  a.Email, a.Nick,a.Name, b.SchoolName,c.DepartmentID,c.CompanyName
FROM         tblUserBaseInfo a,tblUserEducationInfo b , tblUserEmploymentInfo c 
where a.ID = b.ID and a.ID = c.ID

Answer 2

看不出来有什么问题，你把 inner join 换成 left outer join 试试

Answer 3

select a.Email,a.Nick,a.Name,b.SchoolName,c.DepartmentID, c.CompanyName
from tblUserBaseInfo a,tblUserEducationInfo b,tblUserEmploymentInfo c
where a.ID =b.ID and a.ID =c.ID

Answer 4

SELECT     tblUserBaseInfo.Email, tblUserBaseInfo.Nick, tblUserBaseInfo.Name, tblUserEducationInfo.SchoolName, tblUserEmploymentInfo.DepartmentID, 
tblUserEmploymentInfo.CompanyName
FROM         tblUserBaseInfo ,tblUserEducationInfo,tblUserEmploymentInfo where
INNER JOIN tblUserEducationInfo ON tblUserBaseInfo.ID = tblUserEducationInfo.ID 
INNER JOIN tblUserEmploymentInfo ON tblUserBaseInfo.ID = tblUserEmploymentInfo.ID