日期:2014-05-17  浏览次数:20435 次

请问这个是怎么回事呢?
select * from LoanInf where SerialNm='CRM201206180017' order by SerialNm,FollowNm
union all
select * from LoanInfTemp where SerialNm='CRM201206180017' and IsUpdata='False' order by SerialNm,FollowNm
错误原因如下:
Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'union'.
请大家指点。谢谢、。。

------解决方案--------------------
select * from LoanInf where SerialNm='CRM201206180017' order by SerialNm,FollowNm

紅色部分去掉。