我在同一个数据库下建立了三个表:
1,表:project
projectId
projectName
2,表:position
positionId
positionName
3,表:work
workId
workprojectId
workpositionId
workAmount
workTime
workStatus
testTime
int
int
int
int
datetime
binary
int
而projectId和position都是work的外键,对应:workprojectId和workpositionId,要取得如下数据:
projectName, positionName, workAmount,workTime, workStatus, testTime则是如下sql语句(想了老半天,后来在
SQLExpress下查询成功)
SELECT project.projectName, position.positionName, [work].workAmount, [work].workTime,
[work].workStatus, [work].testTime
FROM position INNER JOIN
[work] ON position.positionId = [work].workposition INNER JOIN
project ON [work].workprojectId = project.projectId