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
