Quick SQL query to flatten 2 tables into 1
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
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