[CentOS] I need some help joining data from 3 MySQL tables, please
Les Mikesell
lesmikesell at gmail.comSat May 1 15:15:26 UTC 2010
- Previous message: [CentOS] I need some help joining data from 3 MySQL tables, please
- Next message: [CentOS] Upgrading to 2.6.32
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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_members` AS `m` ON m.teamid = c.id > RIGHT JOIN ( SELECT u.name, u.lastvisitDate FROM `jos_users` ) AS `u` > ON u.id = m.userid > GROUP BY c.id > LIMIT 0 , 30 > > But then I get the error: > > #1054 - Unknown column 'u.name <http://u.name>' in 'field list' Inside the subquery, the table is jos_users (and since there is only one you shouldn't even have to specify it. The 'u' alias is a temporary table holding the result from the subquery. -- Les Mikesell lesmikesell at gmail.com
- Previous message: [CentOS] I need some help joining data from 3 MySQL tables, please
- Next message: [CentOS] Upgrading to 2.6.32
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the CentOS mailing list