SQL Inner Join and a Repeater
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

SQL Inner Join and a Repeater
===

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
