MySQL - select 3 tables with correct left join syntax - Stack Overflow

2012年7月29日 - Your assumption is right: you have to use left JOIN, in this way : SELECT DISTINCT users.name, (SELECT count(id) FROM data WHERE who = 1) as ...

stackoverflow.com