14 replies

Select item collection together with item count

Heads-up: I'm an SQL & Drizzle newbie

I have 3 tables:

users

users

flashcard_collection

flashcard_collection

and

flashcards

flashcards

flashcard_collection

flashcard_collection

has a

creatorId

creatorId

foreign key which indicates what user a collection belongs to

flashcards

flashcards

has a

collectionId

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 count

Select item collection together with item count

Similar Threads

Select item collection together with item count

Similar Threads

Similar Threads

Similar Threads