请问这个是怎么回事呢?
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
紅色部分去掉。