What am I doing wrong with this INNER JOIN query?
Posted on 2012-09-19
Here's my query:
select regional.id, regional.first_name, regional.last_name, regional.email, regional.title, regional.city, regional.state, regional.phone, regions.google_letter, regions.regional_id from regions innner join regional on regional.id=regions.regional_id where regional.id='$assoc_id' order by regions.google_letter
The error that I'm getting is 1054: Unknown column 'regions.google_letter' in 'field list'
There is a google_letter field in the regions table, so I have not idea why that error is happening.
Where am I blowing it?