Old:
> 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
New:
SELECT
topc.id,
topc.topics,
subt.id,
subt.topic_id,
subt.s_topics
FROM
topics topc
INNER JOIN
sub_topics subt
ON
topc.id = subt.id
WHERE
topc.id = subt.id
Might give that a try,
Bill K
-----Original Message-----
From: Michael Haggerty [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 11, 2001 11:28 AM
To: CF-Talk
Subject: RE: Does anyone see a problem with this query?
What is the error you are getting?
-----Original Message-----
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 11, 2001 11:39 AM
To: CF-Talk
Subject: Re: Does anyone see a problem with this query?
Absolutely nothing else.....
Doug
----- Original Message -----
From: "Mike Connolly" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, December 11, 2001 2:12 AM
Subject: RE: Does anyone see a problem with this query?
> I don't know if I'm alone in this, but at first, second, and third glance
> your query syntax seems fine.
>
> Is there anything else to this query?
>
> -----Original Message-----
> From: Douglas Brown [mailto:[EMAIL PROTECTED]]
> Sent: 11 December 2001 00:42
> To: CF-Talk
> 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
