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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
