insert  into 表1(列1,列2.........) select 列1,列2 from 表2

INSERT INTO result
      (stu_no, qst_no)
SELECT '"+stu_no+"', qst_no
FROM question

'"+stu_no+"'表示stu_no为一个变量

INSERT INTO result
      (stu_no, qst_no)
SELECT 999 AS Expr1, qst_no
FROM question

sql1="insert into 员工基本情况表 (员工姓名,所在部门,家庭住址,家庭电话,email) values('"&name1&"','"&bm1&"','"&z1&"','"&tel1&"','"&email1&"')"
conn.execute sql1