请教一个关于Full join的问题
我执行下面的语句:
select bm=isnull(a.bm, b.bm), a.sl, b.rsl, lsl=isnull(a.csl,0)+isnull(b.csl,0)
from (select bm, sl, csl from zz where ...) a
full join
(select bm, rsl=sum(rsl), csl=sum(csl) from mx where ... group by bm) b
on a.bm=b.bm
出错:
[Microsoft][ODBC SQL Server Drive][TCP/IP Sockets] ConnectionRead (recv()).
[Microsoft][ODBC SQL Server Drive][TCP/IP Sockets] General netword error.
Check your network documentation.
Connection Broken
但将数据备份到另一台机子上就没有问题了.请问出这种问题可能是SQL的什么设置不当造成的?
分数不够可以再加.