Recordset

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Might be out of the scope of this forum but it's worth a try. 

I am trying to convert the query below (generated in MS Access ) to one I can use in an ASP page to query an Oracle DB. When I use it I get the error "ORA-00933: SQL command not properly ended"

Any suggestions....

Thanks.

SELECT COR_EMPLOYEES.EMP_ID, COR_EMPLOYEES_APP.NT_USERID, COR_EMPLOYEES.DESIGNATION
FROM COR_EMPLOYEES INNER JOIN COR_EMPLOYEES_APP ON COR_EMPLOYEES.EMP_ID = COR_EMPLOYEES_APP.EMP_ID
WHERE (((COR_EMPLOYEES.DESIGNATION)="SNR MGR"))
ORDER BY COR_EMPLOYEES.EMP_ID;