Venyl
Explore posts from serversDTDrizzle Team
•Created by Venyl on 10/15/2023 in #help
Select item collection together with item count
Heads-up: I'm an SQL & Drizzle newbie
I have 3 tables:
users, flashcard_collection and flashcards
flashcard_collection has a creatorId foreign key which indicates what user a collection belongs to
flashcards has a collectionId foreign key which indicates what collection a flashcard belongs to
I want to select all flashcard collections that belong to a user together with each collection's flashcard count15 replies