请各位帮忙看下,语句问题该怎么处理解决~!
create table ee(
info float,
F2 nvarchar(10),
mc1 nvarchar(255),
dm1 float,
dm2 float,
cke float,
mc3 nvarchar(255),
zt varchar(1)
)
insert ee
select *,case when mc3=mc1 then '1' else '0' end as zt
from(
select a.*,b.dm3,c.mc3
from cc a
full join c3 b on a.dm1=b.dm3
full join c3 c on ltrim(a.dm2)=c.dm3)d
[解决办法]