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)是对的
(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)是对的
(SoundPath, SendTel, ExpertName, ExpertType, RecvTel, LeftTime, bPublic)
SELECT SoundPath, SendTel, ExpertName, ExpertType, '' AS RecvTel, LeftTime,
1 AS bPublic
FROM ExpertPublicWord
WHERE (ID IN
(SELECT MIN(ID)
FROM ExpertPublicWord)) AND (bAct = 0)
(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)
--)
(SoundPath, SendTel, ExpertName, ExpertType, RecvTel, LeftTime, bPublic)
SELECT SoundPath, SendTel, ExpertName, ExpertType, '' AS RecvTel, LeftTime,
1 AS bPublic
FROM ExpertPublicWord
WHERE (ID IN
(SELECT MIN(ID)
FROM ExpertPublicWord)) AND (bAct = 0)