Drizzle Query, Relationship Sub-Query

I have Domains and Products, and a pivot between them (DomainProducts). I'd like to query (findFirst) the DomainProducts where DomainProducts.Slug='hello-world' and DomainProducts.Domain.Url='mydomain.com' Is that possible? It seems like it's not possible to do it with the Query, instead I have to use it like a normal Select and manually do the join?
0 Replies
No replies yetBe the first to reply to this messageJoin