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'.
请大家指点。谢谢、。。
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 LoanInfTemp where SerialNm='CRM201206180017' and IsUpdata='False' order by SerialNm,FollowNm
select * from LoanInf where SerialNm='CRM201206180017'
union all
select * from LoanInfTemp where SerialNm='CRM201206180017'
) tmp worder by SerialNm,FollowNm
select * from LoanInf where SerialNm='CRM201206180017'
union all
select * from LoanInfTemp where SerialNm='CRM201206180017'
) tmp order by SerialNm,FollowNm
select * from (
select * from LoanInf where SerialNm='CRM201206180017'
union all
select * from LoanInfTemp where SerialNm='CRM201206180017'
) tmp order by SerialNm,FollowNm
这个可以达到你要的目的