strSql = "insert into table1(f1,f2) " _
& "values('" & "select f1, f2 from table2 where f3='" & value1 & "'" , '" & value2 & "')"
& "values('" & "select f1, f2 from table2 where f3='" & value1 & "'" , '" & value2 & "')"
& "values('" & "select f1, f1 from table2 where f3='" & value1 & "'" , '" & value2 & "')"
& "values('" & "select f1, f2 from table2 where f3='" & value1 & "'" , '" & value2 & "')"
& "values('" & "select f1, '你必须写一个' from table2 where f3='" & value1 & "'" , '" & value2 & "')"
& "select f1, "& value2 "&" from table2 where f3='" & value1 & "'"
" values(select f1 from table2 where f3='" & value1 & "' , '" & value2 & "')"