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
