I have a database with three tables: questions, tags, and questions\_tags. This is how they are setup:

```
---------
questions
---------
Question_ID
Question_Title
Content

----
tags
----
Tag_ID
Tag_Title

--------------
questions_tags
--------------
Question_ID
Tag_ID

```

In my program, I am using a repeater to display the Question\_Title, and Content. I want to be able to have the Tag\_Title being repeated (with however many tags there are for a certain question as well.

Essentially, I am trying to re-create something similar to that of stackoverflow's question blocks (with the question, tags, views, etc.).

So let's say I have a Question with 5 tags. That question gets inserted into the questions table, along with an ID (auto increment) and the content of the question. Then, with any tag the user attached to the question, those tags would be put into the tags table with an associated ID. Then the questions\_tags table would match up the Question\_ID and Tag\_ID. So it could be something like:

```
Question_ID | Tag_ID
    1       |    3
    1       |    4

```

So question 1 has 2 two tags in this example.
So how can I have the repeater repeat each question in the questions table, and then repeat each tag associated with that question?

I have created a view thus far which inner joins questions, tags, and questions\_tags, but repeating it just repeats a question more than once...

Here is what I had done for the join:

```
SELECT q.Question_ID, qt.Tag_ID, t.Tag_Title, q.Question_Title, q.Content, q.Views
FROM questions q
INNER JOIN questions_tags qt
ON q.Question_ID = qt.Question_ID
Inner JOIN tags t
ON qt.Tag_ID = t.Tag_ID

```

Or, in other words, how could I create a view with my joins such that it creates the table like this?:

```
Question_ID | Tag1 | Tag2 | Tag1_Title | Tag2_Title | Question_Title | Content

```