这条“查询－－插入”语句怎么写？帮帮忙！－－50分

[bxh777]

insert into Table_D (READER,ID,FLAG) values ((SELECT A.b FROM A, B WHERE A.b = B.b AND B.c = '4' GROUP BY A.b),'2143158042','0')";

其中，READER,ID,FLAG 都为字符串型数据，select A.b from ... 查询出的数据也是字符串型数据

这个语句在MS-SQL 里面运行不能通过，请高手帮我改改了。谢谢，在线等。。。

[MorningTea]

这样不行，除非你的(SELECT A.b FROM A, B WHERE A.b = B.b AND B.c = '4' GROUP BY A.b)只有一笔数据，看情况，肯定是不止一条数据，但是你又当成一笔纪录插入，当然有问题，改为：
insert into Table_D (READER,ID,FLAG)
SELECT A.b，'2143158042','0' FROM A, B
WHERE A.b = B.b AND B.c = '4'
GROUP BY A.b

[Frewin]

insert into Table_D (READER,ID,FLAG)
SELECT A.b ,'2143158042','0' FROM A, B WHERE A.b = B.b AND B.c = '4' GROUP BY A.b

[sunqi_790817]

insert into Table_D (READER,ID,FLAG) values ((SELECT top 1 A.b FROM A, B WHERE A.b = B.b AND B.c = '4' GROUP BY A.b),'2143158042','0')";