Hi there 👋 I just asked a question in #prisma2-preview accidentally about prisma1:

Hi, I'm working with prisma1 and wondering how one would do something similar to a SQL

join

using the generated client (edited)

With a [response](https://prisma.slack.com/archives/CKQTGR6T0/p1578044014242700?thread_ts=1578043823.242500&cid=CKQTGR6T0)

you can fetch related data either using the Prisma client's fluent API or using the

$fragment

API: https://www.prisma.io/docs/prisma-client/basic-data-access/reading-data-TYPESCRIPT-rsc3/#relations

However, this doesn't allow me to join on a collection. Why is this? This is possible with the $fragment, why not in the fluent API?