Re: ms access joins

Dan, I'd try adding some parens: Something like: from Games left outer join (Bowlers on games.bowler_rec_id = bowlers.rec_id join (Lane_Assignments on games.L_A_Rec_ID = Lane_Assignments.rec_id where bowlers.Rec_ID = #url.recid#)) Also, I've worked a lot with Access & SQ

ms access joins

I'm having a little trouble joining three tables that are from a Microsoft Access Database. I've created bigger sql statements with SQL Server. Can anybody see if I'm missing something. Here is the error that I'm receiving. [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operat