Oracle 中的合并和匹配表

发布于 2024-11-15 14:40:24 字数 1377 浏览 3 评论 0原文

有谁知道如何将具有公共列名和数据的两个表合并到一个表中？共享列是日期列。这是工作中项目的一部分，这里没有人完全知道它是如何工作的。任何帮助将不胜感激。

table A 
Sub      Temp      Weight    Silicon   Cast_Date
108     2675       2731      0.7002    18-jun-11 18:45
101     2691       3268      0.6194    18-jun-11 20:30
107     2701       6749     0.6976      18-jun-11 20:30
113     2713       2112      0.6616      18-jun-11 20:30
116     2733       3142      0.7382     19-jun-11 05:46
121     2745       2611     0.6949      19-jun-11 00:19
125     2726       1995      0.644      19-jun-11 00:19


table B
Si      Temperature    Sched_Cast_Date     Treadwell
0.6622  2542    01-APR-11 02:57            114
0.6622  2542    01-APR-11 03:07             116
0.7516  2526    19-jun-11 05:46            116
0.7516  2526    01-APR-11 03:40            107
0.6741  2372    01-APR-11 04:03            107
0.6206  2369    01-APR-11 09:43            114
0.6741  2372    19-jun-11 00:19            125

结果如下：

Subcar Temp  Weight Silicon Cast_Date          SI     Temperature Sched_Cast_Date Treadwell
116    2733   3142  0.7382   19-jun-11 05:46   0.7516  2526   19-jun-11 05:46    116
125    2726   1995  0.644    19-jun-11 00:19   0.6741  2372   19-jun-11 00:19    125

我想运行一个查询，仅在 Sched_Cast_Date 和 Cast_Date 相同的情况下返回结果数据。具有相同品质的桌子也能发挥同样的作用。

我希望这更有意义。

原文

Does anyone know how to merge two tables with a common column name and data into a single table? The shared column is a date column. This is part of a project at work, no one here quite knows how it works. Any help would be appreciated.

table A 
Sub      Temp      Weight    Silicon   Cast_Date
108     2675       2731      0.7002    18-jun-11 18:45
101     2691       3268      0.6194    18-jun-11 20:30
107     2701       6749     0.6976      18-jun-11 20:30
113     2713       2112      0.6616      18-jun-11 20:30
116     2733       3142      0.7382     19-jun-11 05:46
121     2745       2611     0.6949      19-jun-11 00:19
125     2726       1995      0.644      19-jun-11 00:19


table B
Si      Temperature    Sched_Cast_Date     Treadwell
0.6622  2542    01-APR-11 02:57            114
0.6622  2542    01-APR-11 03:07             116
0.7516  2526    19-jun-11 05:46            116
0.7516  2526    01-APR-11 03:40            107
0.6741  2372    01-APR-11 04:03            107
0.6206  2369    01-APR-11 09:43            114
0.6741  2372    19-jun-11 00:19            125

the results would look like:

Subcar Temp  Weight Silicon Cast_Date          SI     Temperature Sched_Cast_Date Treadwell
116    2733   3142  0.7382   19-jun-11 05:46   0.7516  2526   19-jun-11 05:46    116
125    2726   1995  0.644    19-jun-11 00:19   0.6741  2372   19-jun-11 00:19    125

I would like to run a query that returns a results data only where Sched_Cast_Date and Cast_Date are the same. A table with the same qualities would work just as well.

I hope that this makes more sense.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

吻风 2024-11-22 14:40:24

您是否想问如何在公共列上连接两个表？ IE

select a.Sub, a.Temp, a.Weight a.Silicon a.Cast_Date, b.SI,
       b.Temperature, b.Sched_Cast_Date, b.Treadwell
from a
join b on b.sched_cast_date = a.cast_date

Are you asking how to join two tables on a common column? i.e.

select a.Sub, a.Temp, a.Weight a.Silicon a.Cast_Date, b.SI,
       b.Temperature, b.Sched_Cast_Date, b.Treadwell
from a
join b on b.sched_cast_date = a.cast_date

回复收藏 0 原文

~没有更多了~