Get all entries from one table together with the count of these entries in another table.

Posted by Emanuil on Stack Overflow See other posts from Stack Overflow or by Emanuil
Published on 2009-12-07T05:18:11Z Indexed on 2010/06/15 16:02 UTC
Read the original article Hit count: 114

Filed under:
|

I've got 3 tables:

  • users (id, name, ...)
  • items (id, name, ...)
  • downloads (user_id, item_id, ...)

How do I get all users together with the number of downloads they have?

© Stack Overflow or respective owner

Related posts about sql

Related posts about mysql