View Single Post
  #4 (permalink)  
Old February 3rd, 2005, 05:02 AM
ChrisScott ChrisScott is offline
Friend of Wrox
 
Join Date: Jul 2003
Location: , , United Kingdom.
Posts: 683
Thanks: 0
Thanked 1 Time in 1 Post
Default

Looks like it might be access's love of brackets around various joins that's the problem, also I think it may complain when you try to do a left join before an outer join.
Give this a try...
Code:
sqlAuthenticate="SELECT userPreferences.msgSort, userPreferences.msgDirection, 
users.username, users.password, users.picLocation, users.firstname FROM (users 
LEFT JOIN userPreferences ON users.username=userPreferences.username) LEFT JOIN
displayOptions on userPreferences.displayID = displayOptions.displayID
WHERE users.username='" & user & "' AND users.password='" & password & "';"
HTH,

Chris

Reply With Quote