请大家帮帮忙,很急,关于视图的!!!!!!!!

[chenyubo83]

现有AA,BB两个表
AA:
A B C D K


BB:
R G H J K
我现在想通过K连接两张表创建视图TEST,但是视图中必须要有AA.A ,BB.G
还有一个字段是想求出BB.H+BB.J的和,我现在就是不知道求和这个怎么写?
请帮帮忙~~一定送分

[smart_zcg]

select AA.A,BB.G,BB.H+BB.J from AA join BB on AA.K = BB.K

[-狙击手-]

select AA.A,BB.G,BB.H+BB.J as HJ
from
AA , BB
where
AA.K = BB.K

[wojila]

怎么上面的答案都没看见视图的影呢？呵呵~
create view TEST
AS
select AA.A ,BB.G,BB.H+BB.J from AA
inner join BB on AA.K=BB.K
不知道这个答案是否和你的意思呢？
谢谢先~~

[一者仁心]

create view test as
select aa.a,bb.g,bb.h+bb.g as bbb from aa join bb on aa.k=bb.k

[一者仁心]

create view test as
select aa.a,bb.g,bb.h+bb.j as bbb from aa join bb on aa.k=bb.k

[e_flying]

create view TEST
AS
select AA.A ,BB.G,BB.H+BB.J
from AA
inner join BB on AA.K=BB.K
不就是这样的吗?