奇特工作室

Select lt.[VoteNum] as PollLT,sms.pollNum as pollXlt, [poll168].poll as poll168,[info].number,[info].name,[info].song,[info].zhiye
,(isnull(lt.[VoteNum],0)+isnull(sms.pollNum,0) +isnull([poll168].poll,0)) as poll
from [lt].[CCJC].[dbo].[SMS_CCJC_VOTE] lt
full outer join [info] on [info].number=convert(int,lt.pid)
full outer join [202.96.86.29].[bestsms].[dbo].[t16600169] sms on convert(int,sms.content)=[info].number
full outer join [poll168] on convert(int,lt.pid)=[poll168].num
Where [info].number IS Not null
order by poll desc