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

Sat May 1 15:15:26 UTC 2010
Les Mikesell <lesmikesell at gmail.com>

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