I am trying to get data from 2 different tables using the statement here:

SELECT EVENT.EventCode, EVENT.CompletedDate, EVENT.CompletedTime, EVENT.NeededTime, EVENT.Comments, EVENT.NeededDate, EVDEF.Desc
FROM EVENT, EVDEF
WHERE EVENT.EventCode = EVDEF.Code AND OrderNumber = 'varOrderNumber'
ORDER BY Sequence

(Event.EventCode and EVDEF.Code being the keys.)

The problem is when I run the query, I get a syntax error every time with <<???>> after the EVDEF.Desc field (see below). In looking at the data in that field, there are trailing space placeholders, so I assume it is a char field.

If I delimit it with 'EVDEF.Desc' in the statement it runs the query, but I get the value "EVDEF.Desc" for that value on every record.

Is there a different way to delimit a char field? What am I doing wrong?

SQL Error Message:

[Pervasive][ODBC Client Interface][Pervasive][ODBC Engine Interface]Syntax Error: SELECT EVENT.EventCode, EVENT.CompletedDate, EVENT.CompletedTime, EVENT.NeededTime, EVENT.Comments, EVENT.NeededDate, EVDEF.Desc<< ??? >> FROM EVENT, EVDEF WHERE EVENT.EventCode = EVDEF.Code AND OrderNumbe

(Note: The << ??? >> appears after the EVDEF.Desc declaration no matter where it is in the statement.

DESC is a reserve word. Use the following:
SELECT EVENT.EventCode, EVENT.CompletedDate, EVENT.CompletedTime, EVENT.NeededTime, EVENT.Comments, EVENT.NeededDate, EVDEF."Desc"
FROM EVENT, EVDEF
WHERE EVENT.EventCode = EVDEF.Code AND OrderNumber = 'varOrderNumber'
ORDER BY Sequence

I didn't realize that. Thanks for the help!