有两个表,A(NAME,NUM1),B(NAME,NUM2),我要输出(NAME,NUM1,NUM2)用SQL语言应该怎么写?
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/30 03:54:28
![有两个表,A(NAME,NUM1),B(NAME,NUM2),我要输出(NAME,NUM1,NUM2)用SQL语言应该怎么写?](/uploads/image/z/6878957-5-7.jpg?t=%E6%9C%89%E4%B8%A4%E4%B8%AA%E8%A1%A8%2CA%28NAME%2CNUM1%29%2CB%28NAME%2CNUM2%29%2C%E6%88%91%E8%A6%81%E8%BE%93%E5%87%BA%28NAME%2CNUM1%2CNUM2%29%E7%94%A8SQL%E8%AF%AD%E8%A8%80%E5%BA%94%E8%AF%A5%E6%80%8E%E4%B9%88%E5%86%99%3F)
有两个表,A(NAME,NUM1),B(NAME,NUM2),我要输出(NAME,NUM1,NUM2)用SQL语言应该怎么写?
有两个表,A(NAME,NUM1),B(NAME,NUM2),我要输出(NAME,NUM1,NUM2)用SQL语言应该怎么写?
有两个表,A(NAME,NUM1),B(NAME,NUM2),我要输出(NAME,NUM1,NUM2)用SQL语言应该怎么写?
select Name,Sum(Num1) Num1,Sum(Num2) Num2 From
(
select Name,Num1,0 as Num2
from A
Union All
select Name,0 as Num1,Num2
from B
) C
group by C.Name