Quick SQL query to flatten 2 tables into 1

Job ID: 34439172

Budget: $10 – $30 USD

Question and answers tables, to have each question with all answers semi colon separated in one row

how to join two tables with common column and concatenate responses into one cell separated with semicolon

Table 1 has questions example:

questionID questionText
1. Do you like apples

Table 2 Answers

AnswerID questionID answerText
1. 1. Yes
2. 1. No
3. 1. I don’t know


I want the results to be

questionID. QuestionText. Answers
1. Do you like apples. Yes; No; I don’t know