[Resolved] Brain Fade

[Reformed]

I am up late programming and I can't figure out why this query is failing. Can someone point out why the following query yeilds the following error. Note that all tables and fields exist and are spelled correctly. The full query is really long, so here's the relevent part. Am I refering to the state_codes.descr improperly?

SELECT prospective_students.id, first_name, last_name, address, city, state_codes.descr, 

The error:

 Error: General error,  message from server: "Unknown table 'state_codes' in field list"

[nemonoman]

is state_codes in the FROM list? That is the typical reason for this error being generated.

Classic error:
FROM state_codes prospective_students ## note no comma

also spelling on both SELECT and FROM sides.

[Reformed]

Here's the complete query:

SELECT prospective_students.id, first_name, last_name, address, city, state_codes.descr, 
postal_code, country_codes.descr, email, dob, main_phone, 
alternate_phone, edu_levels.descr, edu_programs.descr, 
contact_times.descr, affiliates.descr, financial_aid_flag, 
ip_address, edu_program_types.descr, claimed_by_id, created_date, export_flag
FROM
prospective_students, affiliates as a, contact_times as ct, country_codes as c, edu_levels as el, 
edu_program_types as pt, edu_programs as p, state_codes as sc, student_types as st
WHERE
sc.id = state_id
AND
c.id = country_id
AND
el.id = edu_level_id
AND
p.id = edu_program_id
AND
ct.id = contact_time_id
AND
a.id = affiliate_id
AND
pt.id = student_type_id

[Reformed]

Nevemind, like i said, late night brain fade. I have the entire select statment wrong. Dohh! :glare:

[nemonoman]

If you say
FROM state_codes AS sc

You must also say

sc.descr

instead of state_codes.descr

[Reformed]

Nice. I didn't realize that you could use an alias before you declared it. Thanks.