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
