当前位置: 数据库>sqlserver
sql多表联查四种方法
来源: 互联网 发布时间：2014-08-29
本文导语: 本节内容： sql多表联查实例 介绍四个sql多表关联查询的实例代码。 sql多表联查，方法一： 代码示例: select * from order_info as a ,ivrlog4ivrdlvinst as b where (a.saleorder=b.ext1_skill and b.start_date=@date1 and se_id='55' and b.ext1_skill!=...
本节内容：
sql多表联查实例
介绍四个sql多表关联查询的实例代码。
sql多表联查，方法一：
代码示例:
select * from order_info as a ,ivrlog4ivrdlvinst as b
where
(a.saleorder=b.ext1_skill and b.start_date=@date1 and se_id='55' and b.ext1_skill!='')
and convert(varchar(10),a.instime,112)=@date2 and max(a.instime)
where
(a.saleorder=b.ext1_skill and b.start_date=@date1 and se_id='55' and b.ext1_skill!='')
and convert(varchar(10),a.instime,112)=@date2 and max(a.instime)
sql多表联查，方法二：
代码示例:
select * from order_info as a
where a.saleorder=(
select b.ext1_skill from ivrlog4ivrdlvinst as b
where b.start_date=@date1 and se_id='55'
and b.ext1_skill!='')
and convert(varchar(10),max(a.instime),112)=@date2
where a.saleorder=(
select b.ext1_skill from ivrlog4ivrdlvinst as b
where b.start_date=@date1 and se_id='55'
and b.ext1_skill!='')
and convert(varchar(10),max(a.instime),112)=@date2
sql多表联查，方法三
代码示例:
declare
@date1 varchar(20),
@date2 varchar(20)
set @date1='20100812'
set @date2='2010-08-12'
select * from order_info as a
where a.saleorder=
(select b.ext1_skill from ivrlog4ivrdlvinst as b where b.start_date=@date1 and se_id='55' and b.ext1_skill!='')
and convert(varchar(10),a.instime,112)=@date2
and max(a.instime)
@date1 varchar(20),
@date2 varchar(20)
set @date1='20100812'
set @date2='2010-08-12'
select * from order_info as a
where a.saleorder=
(select b.ext1_skill from ivrlog4ivrdlvinst as b where b.start_date=@date1 and se_id='55' and b.ext1_skill!='')
and convert(varchar(10),a.instime,112)=@date2
and max(a.instime)
sql多表联查，方法四
代码示例:
select b.caller, b.start_date, b.start_time, b.ext1_skill,
c.deliveryno, c.destroyresult, c.deliverydate, c.deliverytime, c.arrangetime, c.driverphone, c.drivermobile,
a.servicedate, a.servicetime, a.workertel
from order_info as a ,ivrlog4ivrdlvinst as b ,delivery_info as c
where
a.saleorder in (select b.ext1_skill from ivrlog4ivrdlvinst where b.start_date=@date1 and b.se_id='55' and b.ext1_skill!='')
and convert(varchar(10),a.instime,112)=@date2
order by b.start_date desc, b.start_time desc
c.deliveryno, c.destroyresult, c.deliverydate, c.deliverytime, c.arrangetime, c.driverphone, c.drivermobile,
a.servicedate, a.servicetime, a.workertel
from order_info as a ,ivrlog4ivrdlvinst as b ,delivery_info as c
where
a.saleorder in (select b.ext1_skill from ivrlog4ivrdlvinst where b.start_date=@date1 and b.se_id='55' and b.ext1_skill!='')
and convert(varchar(10),a.instime,112)=@date2
order by b.start_date desc, b.start_time desc
您可能感兴趣的文章:
本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术，将尽最大努力为读者提供更好的信息聚合和浏览方式。
本站(WWW.)站内文章除注明原创外，均为转载、整理或搜集自网络。欢迎任何形式的转载，转载请注明出处。
本站(WWW.)站内文章除注明原创外，均为转载、整理或搜集自网络。欢迎任何形式的转载，转载请注明出处。