Inner Join SELECT statement problem

[BigTime]

Im getting the error: Unknown column 'data2.name' in 'field list' in this SELECT query and I'm at a loss....

 

The table exists the column exists, I can SQL query

 

SELECT refreport.user, refreport.division, refreport.hometeam, refreport.awayteam, refreport.week, refreport.homeleague, refreport.homeconference, refreport.awayconference, data2.name, data2.email FROM refreport INNER JOIN data on data2.user=refreport.user WHERE gameid='$id'";

 

Thanks in advance!

[scootstah]

You're using "data2" but the table is "data", and you have set no aliases.

[BigTime]

see there? 

 

Thanks for your eyes, scootstah!!