SQL..plz帮助中出现错误 [英] getting error in SQL..plz help
本文介绍了SQL..plz帮助中出现错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我在执行时遇到错误.
I am getting below error while executing.
select distinct PD.[Project no], opp.opportunityid a
from [SCM ].ProjectDetail PD right join crmclosedopportunity opp
on PD.CustPOID=opp.opportunityid
error :"Conversion failed when converting from a character string to unique identifier."
推荐答案
PD.CustPOID=opp.opportunityid
看起来上面两个字段的类型不同,因此您的比较失败.
PD.CustPOID=opp.opportunityid
Looks like the types of the two fields above are different, thus your comparision is failing.
这篇关于SQL..plz帮助中出现错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文