关联查询

join：
select a.serverid,c.serverip,a.filename,b.callernumber,b.callednumber,b.createtime,b.releasetime
from dbo.AGENTRECFILE as a
inner join dbo.COLOG as b
on a.coid=b.coid
inner join dbo.DEVICECFG as c
on a.serverid=c.serverid
where b.callernumber='xxx' or b.callednumber='xxx'
order by b.createtime asc

other：
from dbo.AGENTRECFILE a,dbo.COLOG b,dbo.DEVICECFG c
where a.coid=b.coid and a.serverid=c.serverid and (b.callernumber='xxx' or b.callednumber='xxx')
order by b.createtime asc

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!