Select item collection together with item count
Heads-up: I'm an SQL & Drizzle newbie
I have 3 tables:
I want to select all flashcard collections that belong to a user together with each collection's flashcard count
I have 3 tables:
users, flashcard_collection and flashcardsflashcard_collection has a creatorId foreign key which indicates what user a collection belongs toflashcards has a collectionId foreign key which indicates what collection a flashcard belongs toI want to select all flashcard collections that belong to a user together with each collection's flashcard count
