Please any body tell me what is wrong with this query?

Question

User-1148373670 posted

hi All,

please identify that what is mistake in this query:

string CountQuery = @"Select COUNT(DD_DICTATIONID) from as_dictationdtls
                               INNER JOIN AS_PATIENTDTLSCOMMON on DD_TRANSCRIPTID =  PC_TRANSCRIPTID
                               where DD_OWNER = :GlobalID and DD_DICTATIONDATE >= :StartDate and DD_DICTATIONDATE <= :EndDate
            					AND DD_DOCSTATUS >= 100)";

Exception is::ORA-00933: SQL command not properly ended

please solve my issue.

thanks in advance

Answer 1

User904860486 posted

AND DD_DOCSTATUS >= 100)

I think you dont need ) at the end of the query as there is no corresponding (. So try removing this and run your query.

Answer 2

User-1148373670 posted

thanks buddy

u r write.