将填充的列添加到现有表 [英] Adding a populated column to an existing table

问题描述

我有2张桌子，里面有桌子数.就像是 表1:

I have 2 table that have table counts in them. Something like Table 1:

New_Counts
100

表2:

Old_Counts
97

我想创建一个QC表，以便最终检查计数是否在增加:

I want to create a single QC table so I can eventually check that the counts are increasing:

New_Counts|Old_Counts
100|97

有什么主意如何在SQL中做到这一点?联接不会起作用，因为计数永远不会相同.

Any ideas how to do this in SQL? A join won't work since the counts are never the same.

推荐答案

select newcount,oldcount
from (select
    (select count(*) newcount from table1) newcount,
    (select count(*) oldcount from table2) oldcount
    from dual); 

这篇关于将填充的列添加到现有表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！