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

OK, I worked it out. Move on.