I am running a website for job recruitment. I want the recruiter to be able to view the applications that are sitting in an 'application' table in my db.
To make it clear here are my tables
I have a text box which he puts in say his Company name and it looks and mathces it in the Jobs table. I then want this to match his RecruiterID(on my site the users do not know their autonumber ID)in the 'Jobs'table as well. Then do a join to the RecruiterID in the 'Application' table which then i would like everything to then be displayed in the 'Application' as long as its the match to the recruiter. I keep getting the folliwng...........................
Microsoft][ODBC Microsoft Access Driver] The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.
/mkafar/JobRecruiters/posted_applications-jr.asp, line 59
Below is the asp with the sql which was done in access. Im having trouble and just cant get it right.
The SQL is completely invalid. You have 2 FROM clauses, no field list (or a field list out of place), a listing of fields after the WHERE clause, and the single quote in the WHERE clause is either wrong or you need another after the value if it's text. Here's a shortened version that might show the problems:
SELECT FROM Jobs WHERE Company='whatever AND fields FROM Jobs INNER JOIN Application ON Jobs.JobID = Application.JobID;
Well, I considered the ON as part of the INNER JOIN, but if it means that much to you, you are correct. The relevant point to this thread was that the WHERE clause had to be after the FROM...INNER JOIN...ON.