I have a 3 tables with the following data in MySQL

**tags** table

```
id  |   groupId  |   name   |
-----------------------------
1   |      1     |   tag1   |
2   |      1     |   tag2   |
3   |      1     |   tag3   |
4   |      1     |   tag4   |

```

*groupId column here is unimportant right now.*

**practice** table

```
id  |      name      |
----------------------
1   |   practice 1   |
2   |   practice 2   |
3   |   practice 3   |
4   |   practice 4   |

```

and a bridge between the two (**practiceTag** table)

```
id  |   practiceId   |   tagId    |
-----------------------------------
1   |       1        |      1     |
2   |       1        |      2     |
3   |       1        |      3     |
4   |       2        |      1     |

```

But when I try to use the query:

```
SELECT practice.name
FROM practice
INNER JOIN practiceTag ON practiceTag.practiceId = practice.id
INNER JOIN tags        ON practiceTag.tagId = tags.id
WHERE (tags.id =  "1"
AND tags.id =  "2"
AND tags.id =  "3")

```

it doesn't return anything. And thats ok, since I know my query is kinda messed up. But thats as closest as I can get to show you, what I would like my query to do.

I've searched the forums and find out that I can use a group\_concat. But I just can't get it to work.

Any help would be appreciated.

Thanks, Sebastian