I am receiving the error: ORA-00933: SQL command not properly ended
00933. 00000 - "SQL command not properly ended"
*Cause:
*Action:
Error at Line: 51 Column: 3
SELECT *
FROM EMS.vw_tal_dailyptnsum
(SELECT ems.vw_tal_patron.ptnid, ems.vw_tal_patron.firstname, ems.vw_tal_patron.lastname, ems.vw_tal_ptncard.lastmoddate, ems.vw_tal_userauditaction.action
FROM ems.vw_tal_patron, ems.vw_tal_ptncard, ems.vw_tal_userauditaction
WHERE ems.vw_tal_patron.ptnid = Ems.vw_tal_ptncard.ptnid
AND ems.vw_tal_ptncard.lastmoddate BETWEEN TO_DATE('04/24/2021 00:00:00', 'mm/dd/yyyy HH24:MI:SS') and TO_DATE('04/24/2021 23:59:59', 'mm/dd/yyyy HH24:MI:SS')
AND ems.vw_tal_userauditaction.action = 'CREATE USER')
WHERE EMS.vw_tal_dailyptnsum.anntypedesc = 'Sign-Up Date'
AND EMS.vw_tal_dailyptnsum.anndate BETWEEN TO_DATE('04/24/2021 00:00:00', 'mm/dd/yyyy HH24:MI:SS') and TO_DATE('04/24/2021 23:59:59', 'mm/dd/yyyy HH24:MI:SS');
See Question&Answers more detail:os