SQL Query String
Can anyone tell me what's wrong with this SQL query string?
strSQL = "SELECT Recruitment.RecruitID, Recruitment.FirstName, Recruitment.Initial, Recruitment.LastName, Recruitment.AddressLine01,"
strSQL = strSQL & "Recruitment.AddressLine02, Recruitment.AddressLine03, Recruitment.City, City.City, Recruitment.ProvState,"
strSQL = strSQL & "Province_State.Province_State, Recruitment.PostalZIP, Recruitment.PrimaryTelephone, Recruitment.AlternateTelephone,"
strSQL = strSQL & "Recruitment.EmailAddress, Recruitment.DOB, Recruitment.IncomeLevel, Recruitment.IncomeDate, Recruitment.Occupation,"
strSQL = strSQL & "Occupation.Occupation, Recruitment.FocusGroupNum, Recruitment.FocusGroupDate, Recruitment.Notes,"
strSQL = strSQL & "Recruitment.LDEdit, Recruitment.LUEdit, User.Username"
strSQL = strSQL & "FROM [User] INNER JOIN (Province_State INNER JOIN (Occupation INNER JOIN (City INNER JOIN Recruitment ON City.ID = Recruitment.City)"
strSQL = strSQL & "ON Occupation.ID = Recruitment.Occupation) ON Province_State.ID = Recruitment.ProvState) ON User.UserID = Recruitment.LUEdit"
strSQL = strSQL & "WHERE RecruitID = " & ID & ";"
I keep getting the following error:
Syntax error (missing operator) in query expression 'User.UsernameFROM [User] INNER JOIN (Province_State INNER JOIN (Occupation INNER JOIN (City INNER JOIN Recruitment ON City.ID = Recruitment.City)ON Occupation.ID = Recruitment.Occupation) ON Province_State.ID = Recruitment.ProvState) ON User.UserID = Recr'.
Thanks,
Mark
|