有两个表
Requirement
ProjectRequirement:
RID
1 tichu 2012-05-09 00:00:00.000
2 sdasd 2012-05-10 00:00:00.000
3 ce 2012-05-11 00:00:00.000 Project:
RID
1 1 R01
4 1 R02
7 2 R03两个RID是相互关联的,要求得到下面的数据(根据RID把表Requirement中的时间关联到表Project中)1 1 2012-05-09 00:00:00.000 R01
4 1 2012-05-09 00:00:00.000 R02
7 2 2012-05-10 00:00:00.000 R03谢谢。
Requirement
ProjectRequirement:
RID
1 tichu 2012-05-09 00:00:00.000
2 sdasd 2012-05-10 00:00:00.000
3 ce 2012-05-11 00:00:00.000 Project:
RID
1 1 R01
4 1 R02
7 2 R03两个RID是相互关联的,要求得到下面的数据(根据RID把表Requirement中的时间关联到表Project中)1 1 2012-05-09 00:00:00.000 R01
4 1 2012-05-09 00:00:00.000 R02
7 2 2012-05-10 00:00:00.000 R03谢谢。
P.T_PlanBeginTime,P.T_PlanEndTime
from TM_Project P inner join TM_ItemFunction F
on P.FunctionID=F.FunctionID inner join TM_Item T
on F.ItemID=T.ItemID inner join TM_Requirement R
on P.RequirementID=R.RequirementID这个是我写的,其中Requirement 表的PlanEndTime这个 始终是null,麻烦看看怎么修改下
刚是了 b.AddTime这一列全部还是NULL