Prisma

hey guys can somebody point me to examples how to do joins using prisma?

```
query {
  users {
    id
    posts {
      id
    }
  } 
}
```

I would like to join to make a condition. Lets say I have photos with tags and I want to get all photos with some specific tag

conceptually my query above is equivalent to `SELECT User. id, Post.id FROM User, Post where Post.userId = User.id`

I am not sure what you are actually asking :slightly_smiling_face:

Im asking about `select user.id, user.name FROM user INNER JOIN userTags ON userTag.userId = user.id AND  tag.id = tag.id INNER JOIN tag ON tag.name = 'someTag'`

so basically it means give me user tagged by “someTag”, and don’t want to select any other data

yea there's a `where` input field for the `users` query

yeah Im aware about that where, I just wanted to see some example showing how to build that `where` to do what I want

deploy that data model and then explore the API in the Playground :slightly_smiling_face:

thx

```
users (where: {
    photos: {
      filename: "hello.jpg"
    }
  })
```

is something I wanted to do

is prisma always setup a kinda many-to-many relationship even if there is a single relation used?  (`type User { photo: Photo }`)

also, is it possible to see what sql query prisma generates? (enable logging?)

I don't understand your first question :slightly_smiling_face: Maybe it's better to post it here: <https://www.graph.cool/forum/c/questions>
You can use logging from your DB to check the generated queries