Sqlite: Custom join two tables?

I'm kind of stuck with this problem: I have a sqlite database containing two tables connected using a common id. I want to retrieve data from both the tables, and populate a new table say 'table3' having columns 'category_id', 'question', correct_answer', 'wrong_answer1', wrong_answer2', 'wrong_answer3'. How can this be accomplished? Please see the picture below.

Thanks a lot in advance!