Well for one, get rid of the WHERE clause as you're effectively cancelling out the INNER JOIN. It's probably the "topc.topics," bit of the query, but I can't be sure.
Darryl -----Original Message----- From: Mike Connolly [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 11 December 2001 8:12 PM To: CF-Talk 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
