Unknown Column
Posted: Sat Oct 06, 2007 4:40 pm
Code: Select all
SELECT
Website,
Requirement,
State,
Date,
Month,
Year,
CollegeName AS College,
AdID,
Association,
college_vacancies.Position,
college_vacancies.Sport,
DATE_FORMAT(Date,'%%a %%D %%b %%y') AS TheDate,
Sex, State
FROM
college_vacancies,
colleges_list
RIGHT JOIN
students_information AS student
ON
student.Position = college_vacancies.Position
WHERE
college_vacancies.CollegeID = colleges_list.CollegeID
AND college_vacancies.Sport = student.Sport
AND college_vacancies.Position = student.Position
AND Gender = Sex AND student.STUDENTID = %s
AND college_vacancies.`Status` = 1
ORDER BY
Date DESC,
AssociationI'm not sure whats wrong as the column existsUnknown column 'college_vacancies.Position' in 'on clause'
Jcart | Much easier to read the query now isn't it? Please post long queries in a formatted fashion in the future please.