SQL Command not properly ended

Former Member — Tue, 05 Jul 2011 14:58:13 GMT

Hi Experts,

Please help.

When I ran this query, I got a message saying "SQL Command not properly ended". What might be the cause of this error?

In the result field, I have displayed T1.UNIQUE_DOC_NAME, T2.LOCAL_REG_GLB_OBJECT_NAME.

(SELECT <%RESULTS%>

FROM

<%SCHEMA%>.FCI_AUCT_AUCTION_EVENT T1, <%EXT_TABLE(contracts.Contract)%> T2

WHERE

T1.CONTEXTID = <%CONTEXT(contracts.Contract)%> AND T1.OBJECTID = T2.PARENT_OBJECT_ID) TT1

LEFT OUTER JOIN

(SELECT OPT_IN_AGR_OBJECT_ID AS CONTRACT_OBJECT_ID, COUNT(OPT_IN_AGR_OBJECT_ID) AS AGR_COUNT

FROM

<%EXT_TABLE(contracts.Contract)%>

GROUP BY OPT_IN_AGR_OBJECT_ID) OPT_IN

ON TT1.OBJECTID = OPT_IN.CONTRACT_OBJECT_ID

<%ORDERBY%>

Thanks in Advance.

Sharmele.

Re: SQL Command not properly ended

Former Member — Wed, 06 Jul 2011 14:50:05 GMT

I have found the result.

Actually I was trying to Left Outer join the entire query including the select statement.

If I queried as

SELECT <%RESULTS%>

FROM

(

<%SCHEMA%>.FCI_AUCT_AUCTION_EVENT T1

LEFT OUTER JOIN

(SELECT OPT_IN_AGR_OBJECT_ID AS CONTRACT_OBJECT_ID, COUNT(OPT_IN_AGR_OBJECT_ID) AS AGR_COUNT

FROM

<%EXT_TABLE(contracts.Contract)%>

GROUP BY OPT_IN_AGR_OBJECT_ID) OPT_IN

ON T1.OBJECTID = OPT_IN.CONTRACT_OBJECT_ID

)

<%ORDERBY%>

It would have worked fine.

Thanks,

Sharmele.