sqlserver 左连接的写法

最新推荐文章于 2025-06-21 13:59:04 发布

原创最新推荐文章于 2025-06-21 13:59:04 发布 · 6k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sqlserver #upload #join #c

SqlServer 专栏收录该内容

22 篇文章

订阅专栏

本文深入探讨了SQL查询的优化过程，从原始查询到更新后的版本，详细展示了查询语句的调整如何提升性能。通过对比分析，揭示了查询效率提升的关键因素及实践方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >


select a.req_id,a.port_in_did,a.acctid,a.status,a.country,a.port_in_provider,b.calling_plan_name,
c.filetype,a.first_name,a.last_name,a.street_number,a.street_number_suffix,a.pre_directional,
a.street_name,a.street_suffix,a.post_directional,a.secondary_location_description,a.unit,
a.city,a.state,a.zip,a.zip4 
from bb_DID_PORT_IN_REQUEST a,bb_nextone_calling_plan b,bb_did_port_in_upload c 

where a.port_in_provider=b.server_group_id 
and a.acctid*=c.acctid 
and port_in_did = '2012259193'

old
------------------------------------
new

select a.req_id,a.port_in_did,a.acctid,a.status,a.country,a.port_in_provider,
b.calling_plan_name,c.filetype,a.first_name,a.last_name,a.street_number,
a.street_number_suffix,a.pre_directional,a.street_name,a.street_suffix,
a.post_directional,a.secondary_location_description,a.unit,a.city,a.state,a.zip,a.zip4

from bb_DID_PORT_IN_REQUEST a left join
 bb_did_port_in_upload c on a.acctid=c.acctid 
 inner join bb_nextone_calling_plan b on  a.port_in_provider=b.server_group_id
where 
 port_in_did = '2012259193'