Skip to Content
0
Former Member
Dec 17, 2013 at 08:05 PM

Cannot use SELECT

55 Views

I am working my way through the document cr13sp1_cr_usergdr_en.pdf and am trying to make a hierarchial grouping. I'm trying to use the SQL Expression Editor to create a table with employee and supervisor info only.

In the access database that is supplied the SQL syntax is:

SELECT Employee.[First Name], Employee_1.[First Name]

FROM Employee INNER JOIN Employee AS Employee_1 ON Employee.[Employee ID] = Employee_1.[Supervisor ID];

I cannot get this to work in Crystal Reports.

I can't even get this to work:

SELECT `Employee`.`First Name` FROM `Employee`

I get a Syntax Error message:

Error in compiling SQL Expression

Database Connector Error: 'DAO Error Code: 0xc03

Sour: DAO.Database

Description: Syntax error. in query expression 'SELECT `Employee`.`First Name`