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 & SQL queries, but I'm not familiar
with "as Series." What does that do? At first, I thought that might be
your problem, but the error message doesn't sound like it.
Terry
*********** REPLY SEPARATOR ***********
On 11/10/2001 at 9:18 PM Dan Blickensderfer wrote:
>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>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
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
