大侠们帮忙解决下。。查询2个表中字段的和返回i结果。。

[whbwangfei]

这样查询出来怎么没列名，我需要列的名称，
大侠梦帮解决下哈。 急，，，，，，
SELECT
(select sum( kcb.kucongyuliang )as ky from kcb),
(select sum( sum( chajia)as cj )as ky from gxb)

[SQL77]

SELECT 
(select sum( kcb.kucongyuliang )as ky from kcb) AS COL, 
(select sum( sum( chajia)as cj  )as ky from gxb)AS COL1

[--小F--]

[Quote=引用 1 楼 sql77 的回复:]
SQL codeSELECT
(selectsum( kcb.kucongyuliang )as kyfrom kcb)AS COL,
(selectsum(sum( chajia)as cj )as kyfrom gxb)AS COL1
[/Quote]

.....加个别名就好了

[xiequan2]

SELECT
别名1=(select sum( kcb.kucongyuliang )as ky from kcb),
别名2=(select sum( sum( chajia)as cj  )as ky from gxb)

[feixianxxx]

SELECT 
(select sum( kcb.kucongyuliang )as ky from kcb) AS 列名1, 
(select sum( sum( chajia)as cj  )as ky from gxb)AS 列名2

[guguda2008]

不用另开个帖子问吧。。。

[whbwangfei]

哈哈，刚进来找不见前边开的，哈哈。。前边的关了，

[feixianxxx]

[Quote=引用 6 楼 whbwangfei 的回复:]
哈哈，刚进来找不见前边开的，哈哈。。前边的关了，
[/Quote]
你给分提出批评
一楼都正解了 你一分不给。。