INSERT INTO TCONF(AREA_ID,TYPE,VALUE)
SELECT (SELECT AREA_ID FROM TCONF WHERE TYPE=13 AND VALUE=3) AS AREA_ID,35,1AREA_ID 有多个值,这个子查询插入怎么写。。
SELECT (SELECT AREA_ID FROM TCONF WHERE TYPE=13 AND VALUE=3) AS AREA_ID,35,1AREA_ID 有多个值,这个子查询插入怎么写。。
select AREA_ID,35,1 from TCONF WHERE TYPE=13 AND VALUE=3