select top 500 PRO_COREVAD_Begin.rodNO,PRO_COREVAD_Begin.operator,PRO_COREVAD_Begin.machineNO,PRO_COREVAD_END.operator,PRO_COREVAD_END.machineno,PRO_Coremeasurementanddesign.RecordTime,PRO_Coremeasurementanddesign.t_a,PRO_Coremeasurementanddesign.preformdiameter,PRO_TaperShap_Begin.Re,PRO_TaperShap_Begin.State
from PRO_COREVAD_Begin
left join PRO_COREVAD_END on PRO_COREVAD_Begin.rodNO=PRO_COREVAD_END.rodNO
left join PRO_Coremeasurementanddesign on PRO_COREVAD_Begin.rodNO=PRO_Coremeasurementanddesign.rodNO
left join PRO_TaperShap_Begin on PRO_COREVAD_Begin.rodNO=PRO_TaperShap_Begin.rodNO这里最后一行PRO_TaperShap_Begin显示"对象名PRO_TaperShap_Begin无效","无法绑定由多个部分组成的标识符PRO_TaperShap_Begin.rodNO"
请问这是为什么呢?
无法绑定由多个部分组成的标识符PRO_TaperShap_Begin.rodNO"
--表明不明确
select top 500 a.rodNO,a.operator,a.machineNO,b.operator,b.machineno,c.RecordTime,c.t_a,c.preformdiameter,d.Re,d.State
from PRO_COREVAD_Begin as a
left join PRO_COREVAD_END as b on a.rodNO=b.rodNO
left join PRO_Coremeasurementanddesign as c on b.rodNO=c.rodNO
left join PRO_TaperShap_Begin as d on c.rodNO=d.rodNO
这里最后一行PRO_TaperShap_Begin显示"对象名PRO_TaperShap_Begin无效","无法绑定由多个部分组成的标识符PRO_TaperShap_Begin.rodNO"
a.machineNO,b.operator,b.machineno,
c.RecordTime,c.t_a,
c.preformdiameter,
d.Re,d.State
from PRO_COREVAD_Begin a
left join PRO_COREVAD_END b on b.rodNO=a.rodNO
left join PRO_Coremeasurementanddesign c on a.rodNO=c.rodNO
left join PRO_TaperShap_Begin d on a.rodNO=d.rodNO
--你先换成这样,看看哪出错了
from PRO_COREVAD_Begin as a
left join PRO_COREVAD_END as b on a.rodNO=b.rodNO
left join PRO_Coremeasurementanddesign as c on b.rodNO=c.rodNO
left join PRO_TaperShap_Begin as d on c.rodNO=d.rodNO--c.rodNO 改成d.rodNO
改成a.rodNO
select top 500 a.rodNO,a.operator,a.machineNO,b.operator,b.machineno,c.RecordTime,c.t_a,c.preformdiameter,d.Re,d.State
from PRO_COREVAD_Begin as a
left join PRO_COREVAD_END as b on a.rodNO=b.rodNO
left join PRO_Coremeasurementanddesign as c on b.rodNO=c.rodNO
left join PRO_TaperShap_Begin as d on c.rodNO=d.rodNO--"PRO_TaperShap_Begin"无效,d.rodNO:无法绑定由多个部分组成的标识符
--无病乱投医!
select * from [PRO_TaperShap_Begin ]
这样就是对的,求解释