Making findMany act like an inner join?
I'm just starting out with Prisma, so apologies in advance for any stupid questions! 
In SQL, the query below would return one row for each row in [prefs]. Users who had no rows in prefs would not show up. Prefs with no living users would not show up.
In Prisma,
seems to return all the living users, whether they have prefs or not. If I reverse it, and do prefs.findMany, then I get all the prefs, whether they have living users or not. How do I replicate the behavior of the SQL query?
In SQL, the query below would return one row for each row in [prefs]. Users who had no rows in prefs would not show up. Prefs with no living users would not show up.
SELECT users.name, prefs.name, prefs.value
FROM users
INNER JOIN prefs
ON prefs.userId = users.userId
WHERE users.isDead = 0
In Prisma,
users.findMany {
where: { equals: {isDead:0}},
include: { prefs:true}
}
seems to return all the living users, whether they have prefs or not. If I reverse it, and do prefs.findMany, then I get all the prefs, whether they have living users or not. How do I replicate the behavior of the SQL query?
