![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 2 of 2 total |
![]() |
Thu, Apr 6 2006 4:11 AM | Permanent 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 AM | Permanent Link |
Nicholas Hemsley | OK, I worked it out. Move on.
|
This web page was last updated on Wednesday, July 2, 2025 at 06:46 PM | Privacy Policy![]() © 2025 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |