34,587
社区成员
发帖
与我相关
我的任务
分享
set @sql = @sql + ' from (select * from A WHERE UNTI='1#') A LEFT JOIN PR_Batch B ON A.Unti=B.Unti AND A.RecordID=B.RecordID '
报错是'1' 附近有语法错误。
set @sql = @sql + ' from (select * from A WHERE UNTI=1#) A LEFT JOIN PR_Batch B ON A.Unti=B.Unti AND A.RecordID=B.RecordID '
'#' 附近有语法错误。[/quote]
谢谢,这下解决了select @sql = @sql + ' ,SUM(case MaterialCode when ''' + MaterialCode + ''' then ActualQuality else 0 end) [' + MaterialCode + ']'
from (select distinct MaterialCode from B) as a
改成
select @sql = @sql + ' ,SUM(case MaterialCode when ''' + MaterialCode + ''' then ActualQuality else 0 end) [' + MaterialCode + ']'
from (select distinct MaterialCode from B right join A on A.Unti=B.Unti AND A.RecordID=B.RecordID ) as a
SQL提示命令已成功执行,但是不会返回任何结果,这是什么原因额set @sql = @sql + ' from (select * from A WHERE UNTI=‘’1#‘’) A LEFT JOIN PR_Batch B ON A.Unti=B.Unti AND A.RecordID=B.RecordID '
要两个单撇号set @sql = @sql + ' from (select * from A WHERE UNTI='1#') A LEFT JOIN PR_Batch B ON A.Unti=B.Unti AND A.RecordID=B.RecordID '
报错是'1' 附近有语法错误。
set @sql = @sql + ' from (select * from A WHERE UNTI=1#) A LEFT JOIN PR_Batch B ON A.Unti=B.Unti AND A.RecordID=B.RecordID '
'#' 附近有语法错误。
set @sql = @sql + ' from A LEFT JOIN B ON A.Unti=B.Unti AND A.RecordID=B.RecordID group by A.GkID,A.OrderNo,A.Customer,A.Project,A.Unti'
换成
set @sql = @sql + ' from (select * from a where a.unit=1)as a LEFT JOIN B ON A.Unti=B.Unti AND A.RecordID=B.RecordID group by A.GkID,A.OrderNo,A.Customer,A.Project,A.Unti'
试试。