My problem is a bit difficult to explain, easiest by example:

In mysql I have two tables, one with statments from a questionaire and one with answers, something like this:

**First table:**

```
tblstm
StmNo, Statement, LanguageISO3

```

Statment is the formulated question in LanguageISO3, i.e. (1, "Question 1", "ENU"), (2, "Question 2", "ENU"), etc...

**The second table:**

```
tblanswer
RespondentId, Answer

```

Answer is a string with 0 or 1 for yes or no, ie. "01010110110111" for example, the positon of the bit is corresponding to a StmNo in tblstm.

How do I write a query so I get each statment in a seperate row (like tblstm table) with the corresponding answer, for a known RespondentId. The result should be something like this:

```
1, Question 1, 0
2, Question 2, 1
3, Question 3, 0
etc

```