求将3列合并成1列的sql语句

[angleoldhen]

原有3列数据
列名分别为:author1 author2 author3

现在想将后面两列的数据并到第一列来,即只保留author1列,合并的数据用","隔开,要怎么写呢?

[OracleRoob]

select author1 + ',' + author2 + ',' + author3 as author1
from 表名

[点点星灯]

--如果这三列的数据类型都是字符串
select author1+','+author2+','+author3 from tablename

--如果这三列的数据类型都是数字
select convert(varchar(50),author1)+','+convert(varchar(50),author2)+','+convert(varchar(50),author3)
from tablename

[allright_flash]

select author1 + ',' + author2 + ',' + author3 as author
from tablename
where ......
或者
select concat(author1,',',author2,',',author3) as author
from tablename
where ......

[中国风]

update 表
set author1=convert(varchar,author1)+','+convert(varchar,author2)+','+convert(varchar, author3)
update 表
set author1=cast(author1 as varchar)+','+cast(author2 as varchar)+','+cast(author3 as varchar,)

[中国风]

这是更新方法：alter table 表 drop column author2 --删除列名
alter table 表 drop column author3 --删除列名

查询方法改一下就行了
select [author1] =cast(author1 as varchar)+','+cast(author2 as varchar)+','+cast(author3 as varchar)
from 表

[angleoldhen]

可能roy_88比较符合我的意思,前几位只是选择数据,我是想动表结构,把后两列数据和第一列合并后打算把后两列都删除.列里的数据都是字符型

roy_88 :下面这句是将后两列数据移进第一列的吗?

select [author1] =cast(author1 as varchar)+','+cast(author2 as varchar)+','+cast(author3 as varchar)
from 表

[dawugui]

select [author1] =cast(author1 as varchar)+','+cast(author2 as varchar)+','+cast(author3 as varchar)

是的,将不是字符串的数据强行转换为字符串后合在一起.

[xiao_deng]

select author1 + ',' + author2 + ',' + author3 as author1
from 表名

[chenjunjarysky]

mark！