Here is the query that Crystal Report generates: SELECT h.BINNUMBER, h.BINCOUNT, l.LOTID, l.DEVICEPASSPERCENT, r.COMPANYID FROM (REPORTHEADER r INNER JOIN LOTINFO l ON r.REPORT_ID=l.REPORT_ID) INNER JOIN HARDWAREBINS h ON r.REPORT_ID=h.REPORT_ID
and here is the error I get from Crystal and SQL Studio 4200:[SAP AG][SQLOD32 DLL][MaxDB]Syntax error or access violation;-5015 POS(86) Missing keyword:SELECT. Keith Arnold -----Original Message----- From: Koetter, Thomas Theodor [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 02, 2005 8:28 AM To: Keith; Maxdb Subject: RE: Crystal Reports and MaxDB - sql generation Hi Keith > -----Original Message----- > From: Keith [mailto:[EMAIL PROTECTED] > Sent: Dienstag, 1. M�rz 2005 17:50 > To: Maxdb > Subject: Crystal Reports and MaxDB - sql generation > > > We have several clients that use Crystal Reports 9 to > generate reports from > their data warehouses. The db versions are a mix of 7.4 and 7.5. When > creating a report that joins more than 2 tables the SAPDB > ODBC driver return > a syntax error. It appears that the ODBC driver does not > like the syntax > that Crystal Reports uses in its synthesized sql statement. Usually the ODBC driver does not look at the SQL statements. Could you please send traces to for investigation: http://sapdb.2scale.net/moin.cgi/ODBCTrace Regards Thomas ---------------------------------------------- Dr. Thomas K�tter SAP AG, SAP Labs Berlin Do you know SAP^H^H^H MaxDB ? www.mysql.com/products/maxdb www.sapdb.org -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
