sql多表联查实例-mysql教程-PHP中文网

sql多表联查实例

php中文网

发布： 2016-06-07 17:47:33

原创

1730人浏览过

sql多表联查实例下面提供四款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)

方法二

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

方法三

华友协同办公自动化OA系统

华友协同办公管理系统(华友OA)，基于微软最新的.net 2.0平台和SQL Server数据库，集成强大的Ajax技术，采用多层分布式架构，实现统一办公平台，功能强大、价格便宜，是适用于企事业单位的通用型网络协同办公系统。系统秉承协同办公的思想，集成即时通讯、日记管理、通知管理、邮件管理、新闻、考勤管理、短信管理、个人文件柜、日程安排、工作计划、工作日清、通讯录、公文流转、论坛、在线调查、

查看详情

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)

方法四

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