Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread sql querycausing problems on 3.30, fine on 3.19
Thu, Apr 6 2006 4:11 AMPermanent Link

Nicholas Hemsley
A query (& probably alot more.. doh) is causing problems on an ASP website accessing
through ODBC when we upgrade to 3.30.

Here is the query:

SELECT Users.*, Company.*, UsersReports.Fav, UsersReports.RptID, Reports.Report,
Reports.HTMpage
FROM Users
LEFT JOIN Reports ON Reports.RptID = UsersReports.RptID
RIGHT JOIN UsersReports ON Users.UID = UsersReports.UID
LEFT JOIN Company ON Users.CID=Company.ID
WHERE Users.UID='85861805'

running it in dbsys returns the same error

The error:
DBISAM Engine Error # 11949 SQL Error - Internal join error - table correlation name
"UsersReports" in JOIN clause expression is invalid

Thanks in advance

Nick
Thu, Apr 6 2006 4:38 AMPermanent Link

Nicholas Hemsley
OK, I worked it out. Move on.
Image