select a.managecom,
(select b.name from ldcom b where b.comcode = a.managecom) managename,
(select c.codename from ldcode c where c.codetype = 'saletype' and c.code = a.salechnl) salechnlname,
a.agentcode,
a.name,
a.agentstate
from laagent a
where 1 = 1
and a.ManageCom = '86010101'而它的上句类似,却没问题
(select b.name from ldcom b where b.comcode = a.managecom) managename,
(select c.codename from ldcode c where c.codetype = 'saletype' and c.code = a.salechnl) salechnlname,
a.agentcode,
a.name,
a.agentstate
from laagent a
where 1 = 1
and a.ManageCom = '86010101'而它的上句类似,却没问题
错误已经解决,说是 where 后面 的C不认识,你猜猜吧