Error Diagnostic Information
ODBC Error Code = 08S01 (Communication link failure)
Error while executing the query; ERROR: JOIN expressions are not yet implemented
The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (27:1) to (27:52).
Date/Time: Tue Oct 24 23:39:21 2000 Browser: Mozilla/4.72 [en] (X11; U; Linux 2.2.14-5.0 i586) Remote Address: 127.0.0.1 HTTP Referer: http://localhost/vasen.cfm Query String: GroupID=3
This is what Allaire said:
>>>>>>>>
Sounds like the PostgreSQL DB doesn't support this. Can you do it from the psql command line program?
A quick search on www.postgresql.org turned up some join related info, but nothing conclusive.
Allaire Development
>>>>>>>>
Is it really true that Postgre does not support INNER JOIN ?
How can I try that from the psql command line program ?
Where can I look for Postgre error logs on this ?
Searching the site I found something on this, it seems that JOIN queries are possible ?
Best regards,
Aarni