Help with a three table join?

[Mr Chris]

Hi All,

 

I am trying to join three tables with this query:

 

select pl.player_name AS the_player, pl.player_id, s.report_id
  from players as pl
left outer 
  join player_stats as s
    on s.player_id = pl.player_id
left outer 
  join r.reports as r 
    on r.report_id = s.report_id
where pl.player_id = 22

 

However I get the message:

 

SELECT command denied to user 'my_user_name'@'localhost' for table 'reports'

 

However if I just do it without the last join e.g. just a two table:

 

select pl.player_name AS the_player, pl.player_id, s.report_id
  from players as pl
left outer 
  join player_stats as s
    on s.player_id = pl.player_id
where pl.player_id = 22

 

It works fine, so it's getting lost somewhere here on the third join:

 

left outer 
  join r.reports as r 
    on r.report_id = s.report_id

 

But cant see where?  Any ideas?

 

Thanks

[trq]

Its not getting lost anywhere. The user your communicating with mysql as does not have permissions to execute SELECT queries on the reports table.

[Mr Chris]

That's the thing though, if I just do a simple:

 

Select * from reports

 

It works with no problem??

[Ken2k7]

Remove the r. in r.reports. It should be just LEFT OUTER JOIN reports, not LEFT OUTER JOIN r.reports. Makes no sense. It's a minor mistake, I'm sure.