sql - 如何在 ms 访问中使用 UNION 连接两个不同的表

Question

我有以下查询

Select sum (ABC) as ecr from table1 
Where a<>'y' or b is null and c<>'g'

Union all

Select sum(bcd) as ech from table2 

注意：我在一列下得到结果，但我想在两列下显示

标签： sqlms-access

Answer 1

我想你只需要一个cross join

Select sum(ABC) as ecr,
       sum(bcd) as ech
  from table1 t1
 cross join table2
 Where t1.a <> 'y'
    or t1.b is null
   and t1.c <> 'g'