Maybe a stupid question, but does TermID exist in either or both tables?
Darryl
-----Original Message-----
From: Aimee Abbott [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 18, 2001 7:44 AM
To: CF-Talk
Subject: cf 5 can't join fields
Hello all,
I used cold fusion 5 and the Merant database drivers to create a new
database (is this dbase V?) Anyway, now I have created four tables and I
am trying to join two of them. What I would like to do is:
select TERMS.termID, TERMS.term, CROSSREF.crossText
from TERMS, CROSSREF
where TERMS.termID = CROSSREF.termID
but I get an error:
An error occurred retrieving data: ODBC Error Code =S0022 (column not found)
[MERANT]{ODBC dBase driver]Field not found TERMID
Do I need to do joins in some different way with this driver? I have
looked at the odbc*.pdf file that comes with CF5 and it looks like what I
am doing should work just fine. Is there something I need to setup on the
server in some different way????
Aimee
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
