Re: SELECT, COUNT and Inner Join

[Peter Brawley]

This forum is for importing/exporting btw SQLite and MySQL.

The usual sql method to combine names in one table with counts from another that has the same id key is ...

select a.name, b.N
from tbl_with_names as a
join (
  select id, count(*) N
  from tbl_data
  group by id
) b on a.id=b.id;

Edited 1 time(s). Last edit at 11/16/2019 04:37PM by Peter Brawley.