inner join 用法

最新推荐文章于 2025-03-09 18:34:37 发布

zelda002

最新推荐文章于 2025-03-09 18:34:37 发布

阅读量1k

点赞数

分类专栏： Mysql plsql 文章标签： join date

本文链接：https://blog.youkuaiyun.com/zelda002/article/details/6735950

版权

Mysql 同时被 2 个专栏收录

21 篇文章

订阅专栏

plsql

6 篇文章

订阅专栏

本文提供了两个SQL查询案例，包括简单的联表查询与复杂的多表连接及聚合运算示例。通过这些示例，读者可以了解如何在SQL中进行条件筛选、多表关联以及使用函数进行数据处理。

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

1. 简单

select * from (
(select * from tb_trade_9740 where f9740_005v='zhoudeling' and f9740_015n=1)

)tab1
inner join
(select * from tb_trade_0022@p1 ) tab2
on tab1.f9740_010v = tab2.f0022_002v

2.复杂

select
tab_1.f9740_010v,
tab_1.f9740_012n,
tab_1.F9740_014N,
tab_2.F0004_007N,
F0045_007N,
(decode(tab_2.F0004_007N,0,F0045_007N,tab_2.F0004_007N)-tab_1.f9740_012n)*tab_1.F9740_014N
from
(select * from tb_trade_9740 where f9740_005v='heiddy' and f9740_015n=1 and trunc(f9740_001d)=to_date('2011-8-30','yyyy-mm-dd'))
tab_1
inner join
(

select
f0004_001d,
f0004_002v,
F0004_005V,
F0004_007N from tb_ori_0004 where f0004_001d = to_date('2011-8-31','yyyy-mm-dd')   and   f0004_002v =(select max(f0004_002v) from tb_ori_0004 where f0004_001d = to_date('2011-8-31','yyyy-mm-dd'))

)tab_2
on tab_1.f9740_010v=tab_2.F0004_005V
inner join
(
select *
from (select F0045_001D,
               F0045_002V,
               F0045_003V,
               F0045_004V,
               F0045_007N,
               row_number() over(partition by F0045_004V order by F0045_001D desc) rn
          from tb_trade_0045
         where f0045_001d >= trunc(sysdate) - 20
           and f0045_012n > 0)
where rn = 1
) tab_3
on tab_1.f9740_010v=tab_3.F0045_004V