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 operator) in query expression 'games.bowler_rec_id = bowlers.rec_id join Lane_Assignments on games.L_A_Rec_ID = Lane_Assignments.rec_id'. The following is the sql statement. I only receive the error when I try to join the 3rd table (Lane_Assignments) Thanks, Dan <cfquery name="getgames" datasource="Bowling"> select Bowlers.BowlerFirstName, Bowlers.BowlerLastName, bowlers.Rec_ID, games.L_A_Rec_ID, games.bowler_rec_id, games.Game1, games.Game2, games.Game3, games.rec_status, games.Game1 + games.Game2 + games.Game3 as series, Lane_Assignments.date 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# order by Lane_Assignments.date </cfquery> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
