Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 2 of 2 total |
sql querycausing problems on 3.30, fine on 3.19 |
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 Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |