大家帮忙看一下这条语句的问题
INSERT INTO ExpertWord
(SoundPath, SendTel, ExpertName, ExpertType, RecvTel, LeftTime, bPublic)
VALUES (SELECT SoundPath, SendTel, ExpertName, ExpertType, ' ' AS RecvTel, LeftTime,
1 AS bPublic
FROM ExpertPublicWord
WHERE (ID IN
(SELECT MIN(ID)
FROM ExpertPublicWord)) AND (bAct = 0))
报select附近有语发错误
但单独执行
SELECT SoundPath, SendTel, ExpertName, ExpertType, ' ' AS RecvTel, LeftTime,
1 AS bPublic
FROM ExpertPublicWord
WHERE (ID IN
(SELECT MIN(ID)
FROM ExpertPublicWord)) AND (bAct = 0)是对的
[解决办法]
去掉values和括号
[解决办法]
INSERT INTO ExpertWord
(SoundPath, SendTel, ExpertName, ExpertType, RecvTel, LeftTime, bPublic)
--VALUES (
SELECT SoundPath, SendTel, ExpertName, ExpertType, ' ' AS RecvTel, LeftTime,
1 AS bPublic
FROM ExpertPublicWord
WHERE (ID IN
(SELECT MIN(ID)
FROM ExpertPublicWord)) AND (bAct = 0)
--)
