[filipbjerne]

vad kan felet vara??

Fick felmeddelande:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[MySQL][ODBC 3.51 Driver][mysqld-5.0.37-community-nt]Unknown column 'tu.userID' in 'on clause'

SELECT 

tu.userID, tu.userName, tu.userInvitedBy, tu.userPicture, tu.userAddressCity, tue.userEducationSchool, tue.userEducationSchoolAlignment, tuw.userWorkEmployer, tuw.userWorkPosition 

FROM 

tableUser tu, 
tableUserEducation tue, 
tableUserWork tuw 

INNER JOIN 
tableUserEducation tue2 ON tu.userID = tue2.userEducationToID 

INNER JOIN 
tableUserWork tuw2 ON tu.userID = tuw2.userWorkToID 

WHERE 

tu.userName LIKE '%" & functionInjection(Request.Querystring("searchField")) & "%' AND 
tu.userAddressCity LIKE '%" & functionInjection(Request.Querystring("usercity")) & "%' AND 
tu.userAddressCountry LIKE '%" & functionInjection(Request.Querystring("usercountry")) & "%' AND 
tu.userWebsite LIKE '%" & functionInjection(Request.Querystring("userWebsite")) & "%' AND 
tue.userEducationSchool LIKE '%" & functionInjection(Request.Querystring("userEducationSchool")) & "%' AND 
tue.userEducationSchoolAlignment LIKE '%" & functionInjection(Request.Querystring("userEducationSchoolAlignment")) & "%' AND 
tuw.userWorkEmployer LIKE '%" & functionInjection(Request.Querystring("userWorkEmployer")) & "%' AND 
tuw.userWorkPosition LIKE '%" & functionInjection(Request.Querystring("userWorkPosition")) & "%' " & stringSQL & " AND 
tu.userAccept = 1 

GROUP BY 

tu.userID 

ORDER BY 

tu.userName ASC, 
tu.userOnline ASC, 
tu.userLoginDate DESC