Prisma

How are we doing an inner join with Prisma ?

const list: any = await prisma.operateur_forfait.findMany({
    include: {
      operateur_france_tarif: {
        select: {
          id: true,
        },
        where: {
          vers: parseInt(lieuId),
        },
      },
      operateur: true,
    },
  });

Hey :wave:
To remove the records which has no data in operateur_france_tarif you can add <https://www.prisma.io/docs/reference/api-reference/prisma-client-reference#not|not> null condition to the where clause.