DT
Drizzle Teamharshcut
Help needed for Nested Query
For this example, I have 4 tables -
user
, podcast
, episodes
, and bookmarks
.
- bookmarks table has two columns - userId
and episodeId
- each podcast can have multiple episodeId
s, each episode can have only one podcastId
(one to many)
- each user can bookmark multiple episodeId
s, each episode can be bookmarked by multiple userId
s (many to many)
I want to get all the episodeId
s when userId
and podcastId
is provided from the bookmarks table.
harshcut•17d ago
This is what i got working!
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
7.4KMembers
View on DiscordWant results from more Discord servers?
More PostsHow to init sqlite project?https://github.com/drizzle-team/drizzle-orm/issues/2240 ?Typescript performance in larger codebases?Hey, I've been using drizzle with small projects, but now I'm thinking of migrating a larger codebasmultiple dbs, multiple drizzle client, not registering as multiple dbsHey all, anyone know why apiDb shows up as not working? Originally when I had `keys` schema importedSetting triggers with drizzleHey, good day guys. I'm a web developer who recently picked up mysql and drizzle. Going through the