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.