leave out the 'AS' in the from line
At 04:47 PM 12/10/2001 -0800, you wrote:
>P.S This same query works great in query analyzer
>
>
>Doug
>----- Original Message -----
>From: "Douglas Brown" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Monday, December 10, 2001 4:41 PM
>Subject: Does anyone see a problem with this query?
>
>
> > I keep getting this error when I run the query. This is a SQL 2K
> > database
> >
> > ODBC Error Code = 37000 (Syntax error or access violation)
> >
> >
> > [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax
> > near '.'.
> >
> >
> >
> > SELECT topc.id,
> > topc.topics,
> > subt.id,
> > subt.topic_id,
> > subt.s_topics
> > FROM topics AS topc
> > INNER JOIN sub_topics
> > AS subt
> > ON topc.id = subt.id
> > WHERE topc.id = subt.id
> >
> >
> >
> > Thanks
> >
> >
> >
> > Doug
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
