Reported By: Roy Jones Reported On: 9/19/2002 For: Version 3.17 Build 1
# 1232Joining More Than One Table in Crystal Reports 8 Causes a Syntax Error When Running the Query I keep getting an ODBC error: DBISAM Engine Error (11949 SQL Error) Table name expected after FROM keyword instead found '('
I attempted to create a report using the Report Expert and was trying to link 3 or more tables together when I got the above error. I have also tried adding a third table during the report design process, but to no avail.
Comments and WorkaroundsCrystal was adding a bunch of extra parentheses around the joins and DBISAM didn't like that. The workaround was to manually edit the query in Crystal to get rid of the parentheses.
ResolutionFixed Problem on 9/20/2002 in version 3.18 build 1