SQL语句出错
select cxap.xinqiNum from cxap left outer join cxAdmin.adminName on
cxap.adminId=cxadmin.adminid
出错,对象名 'cxAdmin.adminName ' 无效。
select cxap.xinqiNum from cxap
select cxAdmin.adminName from cxadmin均正常。
------解决方案--------------------select c.xinqiNum from cxap c left outer join cxAdmin cA on
c.adminId=cA.adminid
------解决方案--------------------你在做join的时候不能用cxAdmin.adminName, 因为系统不能识别你的表名,所以报错。
ex:
select
c.xinqiNum
from cxap c
left outer join cxAdmin a
on c.adminId=a.adminid