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