What am I doing wrong with this INNER JOIN query?

Posted on 2012-09-19
Last Modified: 2012-09-19
Here's my query:

select, regional.first_name, regional.last_name,, regional.title,, regional.state,, regions.google_letter, regions.regional_id from regions innner join regional on where'$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?
Question by:brucegust
    LVL 107

    Expert Comment

    by:Ray Paseur
    This isn't spelled correctly: innner join but I do not think that is the problem.  I  might write this part of the query differently...

    from regions, regional

    If you can post the CREATE TABLE script for the regions and regional tables we might be able to get a quicker answer.

    Best, ~Ray
    LVL 24

    Accepted Solution

    It's the mispelled  innner that's the problem.  What happened here is "innner" became an alias for regions, the MySQL is now expecting you to refer to innner.google_letter.  Just correct the mispelling and you should be good to go.
    LVL 107

    Expert Comment

    by:Ray Paseur
    @johanntagle: That is exactly why I am a part of EE -- colleagues like you!
    LVL 24

    Expert Comment

    Thanks @Ray_Paseur =)

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    php explode 3 30
    Please help me with my database modeling 7 18
    Add code to body in wordpress site 8 19
    PHP Startup Error 12 0
    Things That Drive Us Nuts Have you noticed the use of the reCaptcha feature at EE and other web sites?  It wants you to read and retype something that looks like this.Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it is …
    Part of the Global Positioning System A geocode ( is the major subset of a GPS coordinate (, the other parts being the altitude and t…
    The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
    The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now