join not supported

[frogggg]

I got this error message on this sql statement:
"SELECT CandidateContactInfo.*, EmployerInfo.* " _
& "FROM CandidateContactInfo LEFT JOIN EmployerInfo " _
& "ON UserName='" & Request.QueryString("txtUserName&quot & "'OR UserName='" & session("UserName&quot _
& "' AND Password='" & Request.QueryString("txtPassword&quot & "'OR Password='" & session("Password&quot & "'"



Is join really not supported? Where is it not supported and why?

 

[cbokowski]

Doesnt look like you are joining correctly. SEE BOLD for example .. assuming that the tables have a relationship

"SELECT CandidateContactInfo.*, EmployerInfo.* " & _
"FROM CandidateContactInfo " & _
"LEFT JOIN EmployerInfo ON EmployerInfo.field = " & _
"CandidateContactInfo.field ..... " & _
"WHERE UserName='" & Request.QueryString("txtUserName&quot & "'OR UserName='" & session("UserName&quot _
& "' AND Password='" & Request.QueryString("txtPassword&quot & "'OR Password='" & session("Password&quot & "'"