高手帮忙？加分？

Question

INSERT INTO Table_a
                          (
                           a1,
                           a2
                          )
                   VALUES( /*为什么加VALUES不能执行？*/ 
                            SELECT DISTINCT
                                   TO_NUMBER(TB1."検討依頼書№"),/*検討依頼書№为什么加""?*/
                                   TB2.型番
                                   
                              FROM TB1 ,
                                   TB2
                                   
                             WHERE TB1.b1 = TB2.b1 
                          )

Answer 1

基本的语法问题去掉values 和 左右括号

Answer 2

INSERT INTO Table_a (a1,a2)
SELECT DISTINCT
TO_NUMBER(TB1."検討依頼書№"),TB2.型番
FROM TB1,TB2
WHERE TB1.b1 = TB2.b1 
/

Answer 3

加values时，后面的括号中是一条记录，而SELECT出的是若干条。
不知道这种理解对不对？

Answer 4

INSERT INTO Table_a
                          (
                           a1,
                           a2
                          )            
                          SELECT DISTINCT
                                   TO_NUMBER(TB1."検討依頼書№"),/*検討依頼書№为什么
                                   TB2.型番
                                   
                              FROM TB1 ,
                                   TB2
                                   
                             WHERE TB1.b1 = TB2.b1 

Answer 5

用了子查询就不能够用values了

Answer 6

TO_NUMBER(TB1."検討依頼書№"),/*検討依頼書№为什么这里应该单引号

Answer 7

INSERT INTO Table_a
                          (
                           a1,
                           a2
                          )
                   VALUE( 
                            SELECT DISTINCT
                                   TO_NUMBER(TB1."検討依頼書№"),
                                   TB2.型番
                                   
                              FROM TB1 ,
                                   TB2
                                   
                             WHERE TB1.b1 = TB2.b1 
                          )
这样也行吧