Microsoft KB Archive/45978

{| = Using Compute within Select Not Allowed in Q+E =
 * width="100%"|

Last reviewed: October 31, 1994

Article ID: Q45978

SUMMARY
Some implementations of SQL allow Compute to be used in the following fashion:

SELECT FIRST_NAME, LAST_NAME, COMPUTE MAX(SALARY) FROM EMP.DBF Q+E's implementation of SQL does not allow this. If the above is entered, the following error message will be displayed: Missing SQL clause: From The correct SQL implementation in Q+E is the following: SELECT FIRST_NAME, LAST_NAME, SALARY FROM EMP.DBF COMPUTE MAX(SALARY)
 * }