sql - Receiving an error in Oracle - Regarding subquery

Question

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');

Answer 1

Looks pretty strange: if you want to join your subquery, you need to add a comma to the end of second line like this:

SELECT *
FROM EMS.vw_tal_dailyptnsum, --< added a comma here
  (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');

But I don't see any join predicates between EMS.vw_tal_dailyptnsum and your subquery. Btw, it would be better to give an alias to your subquery, for example:

SELECT *
FROM EMS.vw_tal_dailyptnsum, --< added a comma here
  (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'
   ) SV --< added an alias "SV" (Subquery View)
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');