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