Re: [CentOS] I need some help joining data from 3 MySQL tables, please

Rudi Ahlers wrote: > > > A google search results suggested the alias should be put after the > bracket. So, I change the code as follow, and move the *AS `u`* outside > the right bracket: > > SELECT c . * , COUNT( m.id ) AS `members` > FROM `jos_mls_teams` AS `c` > LEFT JOIN `jos_mls_teams_me

[CentOS] I need some help joining data from 3 MySQL tables, please

Hi all, I am trying to display collective data from 3 MySQL tables: The query I have, so far, is SELECT c . * , COUNT( m.id ) AS `members` FROM `jos_mls_teams` AS `c` LEFT JOIN `jos_mls_teams_members` AS `m` ON m.teamid = c.id RIGHT JOIN ( SELECT u.name, u.lastvisitDate FROM `jos_users` AS `u` )