SQL error (resolved)

[demotivater]

Does anyone see anything wrong with this sql statement? I'm getting a syntax error on the last join

strMySQL = ""
    strMySQL = strMySQL & "INSERT INTO usys_temp_exception_list "
    strMySQL = strMySQL & "( user_id"
    strMySQL = strMySQL & ", exception_id )"
    strMySQL = strMySQL & "SELECT " & CurrentUserInfo.lngUserID & " AS user_id"
    strMySQL = strMySQL & ", [Exception Condition Reports].[Exception ID] AS exception_id"
    strMySQL = strMySQL & " FROM ([Exception Condition Reports]"
    strMySQL = strMySQL & " LEFT JOIN [Exceptions Copy History] ON [Exception Condition Reports].[Exception ID] = [Exceptions Copy History].[Exception ID])"
    strMySQL = strMySQL & " LEFT JOIN [Exceptions Routing History] ON [Exception Condition Reports].[Exception ID] = [Exceptions Routing History].[Exception ID]"
    strMySQL = strMySQL & " LEFT JOIN detail_exception_actions ON [Exception Condition Reports].[Exception ID] = detail_exception_actions.[Exception ID]"
Debug.Print strMySQL

Thanks in advance

[DiGiTaIErRoR]

That's not a good method... it's slow.... The less strings that you put together the better.

Try:

strMySQL = "INSERT INTO usys_temp_exception_list " & _
"( user_id" & _
"etc."

[demotivater]

Yea, I got it. That's what i ended up doing. I'm fixing someones code and the entire program is written like this, it's really a pain in the rear. Weird that I didn't really change anything though, just combined it all into one line and it worked. Oh well, screw it, it works.

Thanks

[DiGiTaIErRoR]

Yea... other's code can be confusing... improper... and just plain illogical.

Good luck!