select *
,(select UserID from xt_ElecUser where WFID1=WatchKey or WFID2=WatchKey or WFID3=WatchKey)as UserID
,(select UserName from xt_ElecUser where WFID1=WatchKey or WFID2=WatchKey or WFID3=WatchKey)as UserName
,(select UserAddress from xt_ElecUser where WFID1=WatchKey or WFID2=WatchKey or WFID3=WatchKey)as UserAddress
from xt_Watch
where WatchKey in(5629,5642,5643)
,(select UserID from xt_ElecUser where WFID1=WatchKey or WFID2=WatchKey or WFID3=WatchKey)as UserID
,(select UserName from xt_ElecUser where WFID1=WatchKey or WFID2=WatchKey or WFID3=WatchKey)as UserName
,(select UserAddress from xt_ElecUser where WFID1=WatchKey or WFID2=WatchKey or WFID3=WatchKey)as UserAddress
from xt_Watch
where WatchKey in(5629,5642,5643)
select a.*,b.userid,b.username,b.useraddress
from xt_Watch a inner join xt_ElecUser b on b.Wfid1=a.WatchKey or b.Wfid2=a.WatchKey or b.Wfid3=a.WatchKey
where a.WatchKey in(5629,5642,5643)