[CentOS] I need some help joining data from 3 MySQL tables, please
Les Mikesell
lesmikesell at gmail.com
Sat May 1 15:15:26 UTC 2010
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
More information about the CentOS
mailing list