Prisma

image.png

I have an authentication table and users table with one-one relationship and i did with findMany and is but i found some strange because i need to be unique in my database and with findUnique doesnt work with is

I think you'd want to tweak your where query

```where: {
  authentication: {
    where: {
      password
    }
  }
}```

Also, assuming this is just an example but don't save password in plain text!

the where inside another where here didnt work

```where: {
  authentication: { password }
 }```
