How to insert after selecting values from multiple table

Question

INSERT INTO temp_table( 
    case_id, 
    task, 
    Question,
    qa_analyst 
) 
VALUES (
    SELECT 'tt.case_id','tt.Task','abc.questions','tt.qa_analyst'
    FROM (
        SELECT DISTINCT task,questions
        FROM task_questions
    ) abc
    JOIN temp_table tt ON 'abc.task' = 'tt.Task'
)

Answer 1

There is a INSERT ... SELECT statement. And it should be working like this:

INSERT INTO temp_table( 
    case_id, 
    task, 
    Question,
    qa_analyst 
)
SELECT tt.case_id, tt.Task, abc.questions, tt.qa_analyst
FROM (
    SELECT DISTINCT task, questions
    FROM task_questions
) abc
JOIN temp_table tt ON abc.task = tt.Task